isna function

S

Shaun

i am doing a user-system for my ICT GCSE and i am having a bit of a problem,
i am doing an order form sheet and i have used VLOOKUP to find stock and
price etc. i have also prgrammed it to add up the sub total, work out the
VAT and add them both together, my problem is i am getting the error code
#N/A, i have tried the isna fuction to try and hide this as the sub total
column will not add up as their is that error code in every cell, is there
anyway of hiding this error code so that excel will successfully add up the
correct values?
 
P

Peo Sjoblom

Try something like

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A100,0)),VLOOKUP(A1,Sheet2!A2:B100,2,0),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF, ISNA & VLOOKUP 5
=IF(NOT(ISNA(VLOOKUP Function 2
Access Query problem 1
vlookup returning Errors (ISNA formula) 3
isna vlookup #n/a but not false 1
Use both ISNA and ISERROR in a long formula 2
I need help with a IF(ISNA with vlookup 5
#VALUE! error when trying to add cells (VLOOKUP) 6

Top