VLOOKUP Formula not working

[mrsphxbabe]

Can someone look at this code and tell me what I am doing wrong? I am trying to add a column into a spread sheet by taking tghe information from sheet 2 of the workbook.

=IF($B3<>"",VLOOKUP($B3,Sheet2!$A$1:$B$200,2,FALSE),IF($C3<>"",VLOOKUP($C3,Sheet2!$A$1:$B$200,2,FALSE),VLOOKUP($D3,Sheet2!$A$1:$B$200,2,FALSE)))

It only returns the value of #N/A

What am I doing wrong?
Thanks for your help!

 

[Joe4]

That means that it is not finding a match for whatever value it is trying to look up (B3, C3, or D3).
Note that the values must match EXACTLY and be of the same data type.
So, you cannot match a number to text (if you have a number entered as text, it is not treated as a number!)
Also, if there are any extra spaces at the end of either value, and they are not the same, they will not match either (i.e. "A " will not match to "A").