Vlookup Formula Help


K

KC

I want to put a formula in cell I150 that says look up the code in cell G150
and go find that code in the List tab in column A, then return the text in
column C on the list tab. And, if you don't find the code on the List tab,
then leave the cell blank. I've tried the formula below, but its not working
correctly, i get a #REF! in the cells that should return a code.

=IF(ISNA(VLOOKUP(G150,List!A:A,2,0)),"",VLOOKUP(G150,List!A:A,2,0))
 
Ad

Advertisements

E

Eduardo

Hi,
try

=IF(ISNA(VLOOKUP(G150,List!A:C,3,false)),"",VLOOKUP(G150,List!A:C,3,false))
 
Ad

Advertisements

L

L. Howard Kittle

I'll bet you $100 you meant to column 3 instead of 2 in your formula.>G>

Regards,
Howard
 

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