Checking Data in Excel =VLOOKUP formula

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...

Should You Turn Off Computer at Night?

Uninstall microsoft trial version

Answers

Only 1 answer

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.

Bushwhacker

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 answer

Do you know the answer?