if one cell matches an array then output specific cell from array

[acousticsman]

I have a list of teams and Stadiums they play in
Column 1 - Column 2
Team 1 - Stadium 1
Team 2 - Stadium 2
Team 3 - Stadium 3
Team 4 - Stadium 4

in another page I have the fixtures list -
Column 1 vs Column 2 - Stadium
Team 1 vs Team 2 - [in this cell I want to put a formula in that will show the stadium they played in]*
Team 3 vs Team 4 - [in this cell I want to put a formula in that will show the stadium they played in]*

etc etc
* the team to reference will be the one in column 1

any help me with which formula this is possible?

[NBVC]

I think you just need a VLOOKUP

e.g.

=VLOOKUP(A1,List1,2,0)

where List1 is the range of teams and stadiums.

[acousticsman]

thanks! I knew about vlookup just forgot how to use it! :D

[acousticsman]

how do I mark this thread as solved?

[NBVC]

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save