News1 min ago
Checking Data in Excel =VLOOKUP formula
1 Answers
I have two spreadsheets. One has a list of 1,000 Unique Reference Numbers (URN's) on it and each of these is classed as either A, B, or C.
I have another spreadsheet with only 500 of these URN's on it and want to find out which class each of these are (A, B, or C).
Obviously I have simplified this example for ease of explanation, but can anyone tell me the basics of how to do this formula? I beleve you use =VLOOKUP somehow but this one is quite new to me...
I have another spreadsheet with only 500 of these URN's on it and want to find out which class each of these are (A, B, or C).
Obviously I have simplified this example for ease of explanation, but can anyone tell me the basics of how to do this formula? I beleve you use =VLOOKUP somehow but this one is quite new to me...
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.I will take it for granted that the sheet with the 1,000 URNs is Sheet1 and that the URNs are in column A and the A,B,C classification is in column B.
I will also take it that your 500 URNs are on Sheet2 and are in column A.
I will also take it that both Sheet1 and Sheet2 have column headers in row A.
So in cell B2 of Sheet2, insert the following function :
=VLOOKUP(A2,Sheet1!$A$1:$B$1001,2,FALSE)
and fill this down column B of sheet2.
That should sort you out.
BW
I will also take it that your 500 URNs are on Sheet2 and are in column A.
I will also take it that both Sheet1 and Sheet2 have column headers in row A.
So in cell B2 of Sheet2, insert the following function :
=VLOOKUP(A2,Sheet1!$A$1:$B$1001,2,FALSE)
and fill this down column B of sheet2.
That should sort you out.
BW
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.