=if(isna(vlookup(a9,datasheet!b3:bu29,3,false)),"n o 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.)



Claire wrote:

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 29) & 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!!

--
CMB BT

"smiley61799" wrote:

Thank you soooooo very much. This helped me out a great deal. It worked
beautifully!

"Gord Dibben" wrote:

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

On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799
wrote:

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)



--

Dave Peterson