Index, Match?

[kiyo052]

I think this is a match and index but not 100% sure how to do it.

Need Formula for A1 to A5 depending on what B contains
Table is from F1: G4

	A	B	C	D	E	F	G
1	Justin	Team 3				Team 1	Steve
2	Justin	Team 3				Team 2	Will
3	Chris	Team 4				Team 3	Justin
4	Steve	Team 1				Team 4	Chris
5	Will	Team 2

<tbody>
</tbody>

 

[mole999]

quite a good example of working here > https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/

I never remember what I need until I work it through

 

[63falcondude]

Like this?

Excel 2010
	A	B	C	D	E	F	G
1	Justin	Team 3				Team 1	Steve
2	Justin	Team 3				Team 2	Will
3	Chris	Team 4				Team 3	Justin
4	Steve	Team 1				Team 4	Chris
5	Will	Team 2
Sheet1

Cell Formulas
Range	Formula
A1	=INDEX(G:G,MATCH(B1,F:F,0))