Vlookup Across Columns

[hardeep.kanwar]

Dear All,


I have Table, that have Codes and in the Last Column there is Campus Name

In another Table i have only Codes, Now what i Want to Know the Campus Name from these Codes

See the Table

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
2	Codes	Codes	Codes	Codes	Codes	Codes	Codes	Codes	Codes	Codes	Campuses
3	9848	9948	9912	9951	9705	9010	9603	9640	9666	9505	Delhi
4	9542	9553	8096	-	-	-	-	-	-	-	Delhi
5	9849	9866	9949	9989	9908	9963	9959	9704	9701	9000	Mumbai
6	9177	9618	9652	9676	9502	9550	9573	8008	8106	8897	Mumbai
7	8978	7702	-	-	-	-	-	-	-	-	Mumbai
8	9885	9985	9966	9703	9052	9642	9160	9581	8142	7799	Mumbai
9	9440	9441	9490	9491	9492	9493	9494	8985	-	-	Bangalore
10	9700	8801	-	-	-	-	-	-	-	-	Bangalore
11	9030	8019	9032	8121	8125	8143	8977	7842	-	-	Kolkata
12
13
14	Codes	Expected Result
15	8096	Delhi
16	9966	Mumbai
17	9032	Kolkata
18	9951	Delhi
19	9603	Delhi
20	9573	Mumbai
21	8106	Mumbai
Sheet1

Thanks in Advance

 

[Andrew Poulsom]

This worked for your sample data:

=INDEX(K$1:K$10,SUMPRODUCT((C$1:J$10=A15)*ROW(A$1:A$10)))

 

[hardeep.kanwar]

This worked for your sample data:

=INDEX(K$1:K$10,SUMPRODUCT((C$1:J$10=A15)*ROW(A$1:A$10)))

Thank you So Much Sir, Its Also Work in Actual Data


Thanks Again