Index Vlookup Required

[troy001100]

Hi

I am trying to write a query for the below link
https://imgur.com/a/J55Z2xc

Any help would be greatly appreciated


Thanks

 

[AhoyNC]

If you have Excel ver. 2010 or later and assuming you don't have duplicates in your data of numbers try:
If you can have duplicates there will need to be some changes made to the formula.

Excel Workbook
	A	B	C	D	E
1	Name
2	Name1	1
3	Name2		2
4	Name3	3	8
5	Name4			5
6	Name5		4		7
7
8
9	1	Name1
10	2	Name2
11	8	Name3
12	7	Name5
Sheet