I need to do what I think should be a simple vlookup formula...but I have no idea how to properly enter the formula to achieve the result I need.
Quite simply, I have 2 different worksheets. Each worksheet has a column of different unique alphanumeric values. (product SKU's, actually)
I want to build a Vlookup or similar formula that will look at the unique alphanumeric value in the first sheet, and reference the 2nd sheet to see what the value in a corresponding column (same row) is for that.
For example,
In Column A, Row 1, on Worksheet 1, the value is: AA1
In Column A, Row 144, on Worksheet 2, the value is: AA1
In Column B, Row 144, on Worksheet 2, the value is: 1234
What I want to do is be able to enter a formula on the first worksheet that will help me to the find that "1234" value on the 2nd worksheet.
Any advice/tips?
Bookmarks