Looking to use VLOOKUP to compare two different columns from two different sheets for matching value, and where value matches in Sheet A Column A and Sheet B Column A, copy values from Sheet B Column B to Sheet A Column B.
Where value in column A matches B.
SheetA SheetB SheetA becomes
Column A Column A Column B Column A Column B
1 2 Yes 1
2 3 No 2 Yes
3 5 No 3 No
4 0 Maybe 4
Formula I tried.
No matter what i try i cannot get it to reference a value correctly in SheetB, even though I know there is one that matches $A$2 from SheetA.