CODEWITHSUNDEEP
excelexcel-formula
BLS93
BLS93

Reputation: 335

VLOOKUP - multiple returns in excel

I'm trying to pull the country codes from sheet 1 (image 1) to sheet 2 (image 2).

I understand how to do a simple vlookup =VLOOKUP(SF!A11,SF!A:B,2,FALSE). However, I don't want to have to do it 68 more times. Is there a way to do the whole process in one function?

I guess it could be done by somehow matching the country names and feed in the country codes by name match?

Images below.

Rookie post - TIA.

Image 1 Image 2

Upvotes: 0

Views: 83

Answers (1)

Jordan
Jordan

Reputation: 4514

Try this in cell C2 in your 'JJ' sheet and copy down:

=VLOOKUP($A2,SF!$A:$B,2,FALSE)

You only needed to change the cell you were referring to from A11 in the 'SJ' worksheet to A2 in the 'JJ' worksheet.

Upvotes: 2

Related Questions