Formula Help

[bwlytkr]

What would be the best formula to use if column B matches something in column X, populate adjacent info in cell Y in column P in same row as column B.

 

[Fluff]

Either Vlookup, or Index/Match

 

[bwlytkr]

Thanks. Kind of new to excel. Would you have an idea on how the formula should look? Never seen and Index formula before

 

[Fluff]

Like this

Excel 2013/2016
	B	P	X	Y
1	Ward		Ward	Introduced
2	Ashley	2	St Peters	1
3	Batchwood	14	Ashley	2
4	Clarence	4	Sopwell	3
5	Hatfield Central	6	Clarence	4
6	Hatfield Villages	9	Hatfield Central	6
7	London Colney	10	Welham Green and Hatfield South	8
8	Park Street	11	Hatfield Villages	9
9	Redbourn	15	London Colney	10
10	Sopwell	3	Park Street	11
11	St Peters	1	St Stephen	12
12	St Stephen	12	Verulam	13
13	Verulam	13	Batchwood	14
14	Watling	17	Redbourn	15
15	Welham Green and Hatfield South	8	Watling	17
16			Colney Heath	19
17			Wheathampstead	20
18			Sandridge	22
19			Marshalswick North	23
20			Harpenden South	24
21			Harpenden West	25
22			Harpenden North	28
Data

Cell Formulas
Range	Formula
P2	=INDEX($Y$2:$Y$29,MATCH(B2,$X$2:$X$29,0))

 

[bwlytkr]

WOW. Great Thanks for the help. Worked great

 

[Fluff]

You're welcome & thanks for the feedback