#NA error when doing a look up

J

Jeff

I have the following formula that I am having a problem with.

=IF(R589=FALSE,G589,VLOOKUP(M589,Feature_Average,4,))

basically I am looking for a value in a cell if the cell is blank I look at
another column in the row to find a value.

using that value I go to another worksheet and get a value.

so in english,

A B C
1 Car 1 3 Red
2 Car 2
3 Car 3 Blue

in row one the formula above would return 3
in row two the forumal above would retrun #NA
in Row Three the formula above would retrun 6 (it is doing a look up in
another table)

the problem is in row 2 how do I look for a blank value in a table? I have
a row that is blank but for some reason the lookup does not find it.

Any ideas?

Thanks

jeff
 
S

ShaneDevenshire

Hi,

VLOOKUP considers the blank in cell R589 as having a value of 0, so to make
this work enter the value 0 in the first colum of the lookup table on the row
which now contains a blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top