IF Function-Logical Vlookup Error

Hi,

I am trying to lookup J3 to see if it is also in the VSN spreadsheet and if it is there, then pull it into the current spreadsheet. However, if it is not in the VSN spreadsheet then, the use the original value/word in J3.

The logical function works if the item is in the VSN spreadsheet, but I get N/A# when it is not. I have formatted the columns as numbers even if they contain text.

Can someone please help?

=IF(J3=(VLOOKUP(J3,'VSN with ID#s'!$A$1:$C$79,1,FALSE)),VLOOKUP(J3,'VSN with ID#s'!$A$1:$C$79,3,FALSE),J3)

It worked! Thank you so much!

Originally Posted by Fotis1991

Try

=iferrror(IF(J3=(VLOOKUP(J3,'VSN with ID#s'!$A$1:$C$79,1,FALSE)),VLOOKUP(J3,'VSN with ID#s'!$A$1:$C$79,3,FALSE),J3),"")