Reputation: 335
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.
Upvotes: 0
Views: 83
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