isna function

  • Thread starter Thread starter Shaun
  • Start date Start date
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?
 
Try something like

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