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(G1 50,List!A:A,2,0))

Hi,
try

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

"KC" wrote:

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(G1 50,List!A:A,2,0))

Try:

=IF(ISNA(VLOOKUP(G150,List!A:C,2,FALSE)),"",VLOOKU P(G150,List!A:C,2,FALSE))


"KC" wrote:

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(G1 50,List!A:A,2,0))

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

Regards,
Howard

"Dan" wrote in message
...
Try:

=IF(ISNA(VLOOKUP(G150,List!A:C,2,FALSE)),"",VLOOKU P(G150,List!A:C,2,FALSE))


"KC" wrote:

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(G1 50,List!A:A,2,0))