Still looking to be rid of the #N/A on look up table

  • Thread starter Thread starter smiley61799
  • Start date Start date
S

smiley61799

I am not good at this at all, novice at best. This is my current formula,
are you able to tell me how to alter my formula to yield a - or 0? I
appreciate your help

=VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE)
 
=IF(ISERROR(VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE)),"-",VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE))
 
First of all.................your lookup value cannot be a range of cells so
you must re-write the original formula.

=VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)

Now to get rid of the #N/A

=IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)),"",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))

Copy down as far as you need.


Gord Dibben MS Excel MVP
 
Thank you soooooo very much. This helped me out a great deal. It worked
beautifully!
 
Hi

I've been searching through posts on various websites to try & help me get
rid of #N/A within a formula to no avail.

Can you please help???

My formula is =VLOOKUP(A9,'datasheet'!B3:BU29,3,'datasheet'!D3:D29) & I
have tried suggestions with IF(ISNA & IF(ISERROR but nothing seems to work -
unless the my 2 conditions in the VLOOKUP are found - help!!
 
=if(isna(vlookup(a9,datasheet!b3:bu29,3,false)),"no match",
vlookup(a9,datasheet!b3:bu29,3,false))

I used False as the last (4th) parameter in the =vlookup() function. That means
I want an exact match to A9.)
 
ps.

If I only needed to look at 3 columns (B:D) in the datasheet, I'd adjust the
formula:

=if(isna(vlookup(a9,datasheet!b3:d29,3,false)),"no match",
vlookup(a9,datasheet!b3:d29,3,false))
 
Thank you Soooo much Dave - your a life saver!
--
CMB BT


Dave Peterson said:
ps.

If I only needed to look at 3 columns (B:D) in the datasheet, I'd adjust the
formula:

=if(isna(vlookup(a9,datasheet!b3:d29,3,false)),"no match",
vlookup(a9,datasheet!b3:d29,3,false))
Click to expand...
 
Back
Top