Vlookup Formula Help

  • Thread starter Thread starter KC
  • Start date Start date
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))
 
I'll bet you $100 you meant to column 3 instead of 2 in your formula.>G>

Regards,
Howard
 
Back
Top