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))