Inserting a description for an acronym from one spreadsheet into another

[MonaSpence]

Good evening. I have two spreadsheets. Spreadsheet 1 has a schedule of our hockey games and what arena that game is located but the arena is just the acronym. Spreadsheet 2 is a list of hockey arenas with their acronyms and their description. How can I get excel to populate spreadsheet one with the descriptions from spreadsheet 2 by recognizing the acronym? Sorry I'm not sure if I have explained it correctly.

SPREADSHEET 1 SPREADSHEET 2
Arena ID Arena Arena ID Arena
SOC SOC Strathcona Olympiette Centre & Fultonvale Arena

[protonLeah]

=vlookup($d2,sheet2'$a:$b,2,false)

[MonaSpence]

=vlookup($d2,sheet2'$a:$b,2,false)

Thanks I will try that!

[MonaSpence]

ProtonLeah, Can you help me a bit further with a formula to add the address for the arena beside the arena name?

I had tried =VLOOKUP($D2,Sheet2!C3:D388,2,FALSE) but I received an error.

[CAntosh]

ProtonLeah doesn't appear to be online, so I hope he doesn't mind me jumping in - Where is the address located on sheet 2? With VLOOKUP, the first column in your lookup range (C3:D388) should be the column you're searching for a match in, then the "2" in your formula tells Excel to show the result from the 2nd column of that lookup range. Your formula:

=VLOOKUP($D2,Sheet2!C3:D388,2,FALSE)

Tries to look up $D2 in Sheet2 column C and should return Sheet2 column D from that match. If the address you want is in Sheet2 column D, it looks to me like you want:

=VLOOKUP($D2,Sheet2!$A$3:$D$388,4,FALSE)

This will look in sheet2 column A for a match and return the corresponding result in sheet2 column D. Hopefully that helps?

[MonaSpence]

ProtonLeah doesn't appear to be online, so I hope he doesn't mind me jumping in - Where is the address located on sheet 2? With VLOOKUP, the first column in your lookup range (C3:D388) should be the column you're searching for a match in, then the "2" in your formula tells Excel to show the result from the 2nd column of that lookup range. Your formula:

=VLOOKUP($D2,Sheet2!C3:D388,2,FALSE)

Tries to look up $D2 in Sheet2 column C and should return Sheet2 column D from that match. If the address you want is in Sheet2 column D, it looks to me like you want:

=VLOOKUP($D2,Sheet2!$A$3:$D$388,4,FALSE)

This will look in sheet2 column A for a match and return the corresponding result in sheet2 column D. Hopefully that helps?

Thanks for the explanation! I always try to figure it out using the answer i am given so i understand it. So thanks again!