Vlookup

[Xirom431]

Hi,

I have this formula

=IF(ISNA(VLOOKUP(F824,'[Blending & Mixing JET-Device List via Tag List_To Plant_20101201.xlsx]Complete Device List'!$E$2:$F$889,2,FALSE)),"",(VLOOKUP(F824,'[Blending & Mixing JET-Device List via Tag List_To Plant_20101201.xlsx]Complete Device List'!$E$2:$F$889,2,FALSE)))

I need to compare Column F on both ws. If they match, it will get the info from Column B in WS 2 and copy to Column B in WS1. I couldn't get it to work. I use Office 2010. Thanks for the help

 

[Bagharmin]

With the formula you gave, you are asking Excel to see if the value in cell F824 is found in column E of worksheet 2 and, if it's there, to give you the value in column F of worksheet 2 (or "" if it isn't there). Since column B is to the left of the range you're searching with VLOOKUP, there's no way for VLOOKUP to find it. You could copy the values in column B and place them, say, in column G on worksheet 2 and change the "$E$2:$F$889,2" portion of your formula to "$E$2:$G$889,3" and that should get you what you need.