Hello,
I thought I was confident in using Excel but I'm struggling to make VLOOKUP work how I want it to.
I have 2 sheets both with data laid out differently. In Sheet1 I want column A to be a list of reference numbers and then column B to have a list of names associated with those reference numbers. In Sheet2 I want it to have a similar list of reference numbers in Column A but then in Column B I want it to auto populate by looking at what is in Sheet1.
So for example in Sheet1 cell A1 will have the value "11111" and B1 "John". On Sheet2 I want it to populate any B column cell with "John" that has an A column cell that says "11111". If it can't find a match then it should simply say "N/A" or "Not Found".
I'm trying to match up names to reference numbers based on a separate set of data and I'm struggling to make this work. I hope this makes sense!
Bookmarks