Donate SIGN UP

Checking Data in Excel =VLOOKUP formula

Avatar Image
funkylad20 | 12:45 Tue 10th Mar 2009 | Computers
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...



Gravatar

Answers

Only 1 answerrss feed

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

Only 1 answerrss feed

Do you know the answer?

Checking Data in Excel =VLOOKUP formula

Answer Question >>

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.