What I have:
I have 2 sheets. On Sheet 1, I have a list of 20 numbers (in column A) that I need to pull data for. On Sheet 2, I have a large quantity of data.
I ran a VLookUp function (Sheet1, column B) to determine if any of my 20 numbers exist in column A of sheet 2.
Excel.JPG
What I need:
If my VlookUp function returned a matching value; I want column C on sheet 1 to display the value of Column B, sheet 2, that corresponds to it.
Attached is a very very simplified file of what I have.
I am open to different ways of approaching this problem. Thank you in advance for any assistance!
Bookmarks