how to eliminate N/A error in vlookup?

  • Thread starter Thread starter lina
  • Start date Start date
L

lina

hi,

how can i get rid of the N/A error when using vlookup formula?

is it a must to put "false" if i want to get the exact figure i want?

i tried to remove "false" in the formula. it did give me some figure
but not the one i want...

how to solve this problem
 
You might want to change from vlookup to Index/Match. If you do, the
do a Search on Index/Match at the first page of this Forum. You wil
find a couple different ways to solve the N/A problem. I had th
same question a couple months ago
 
Nest your vlookup formula within an IF and ISERROR
formula.

Eg. =IF(ISERROR(VLOOKUP(A1,B2:F25,3,FALSE),"",VLOOKUP
(A1,B2:F25,3,FALSE))

This formula says IF the vlookup returns an error (ie.
N/A) then show "", else return the true result of the
vlookup.

Hope this helps, Paddy
 
Back
Top