Excel 2007 : VLOOKUP for #N/A values

[SCLai]

Is it possible to use vlookup to search for #N/A entries?

e.g...

------ A ------ B
1 - V145 - 102
2 - V167 - 096
3 - #N/A - 034
4 - V175 - 145

I have tried =VLOOKUP(NA(),A1:B4,2,0), it gave me a non-error #N/A
and =VLOOKUP("#N/A",A1:B4,2,0), it gave me a #N/A indicating not found

What I am trying to get is "034" in cell B3, is it possible?

Thanks for the help in advance!

[vish2025]

Hi,

You can use single cot ( ie ') before #N/A like '#N/A.

Vish

[arthurbr]

Are you going to have multiple NA's in col A?

[SCLai]

Hi,

You can use single cot ( ie ') before #N/A like '#N/A.

Vish

Oh.. the #N/A in Column A is the result of a not-found VLOOKUP.. it isnt actually text

Are you going to have multiple NA's in col A?

Yes, very likely...