Vlookup Technique Help

[Excel777]

Hey,
Plz Need Help In This Loopup Technique

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Formula	My Range	Tables List		Data	Results		Table1		Table2		Table3
3	#N/A	A1:A9	Table2		A1	100		A1	1	A1	100	A1	1000
4					A2	101		A2	2	A2	101	A2	1001
5					A3	102		A3	3	A3	102	A3	1002
6					A4	103		A4	4	A4	103	A4	1003
7					A5	104		A5	5	A5	104	A5	1004
8					A6	105		A6	6	A6	105	A6	1005
9					A7	106		A7	7	A7	106	A7	1006
10					A8	107		A8	8	A8	107	A8	1007
11					A9	108		A9	9	A9	108	A9	1008
12								A10	10	A10	109	A10	1009
13								A11	11	A11	110	A11	1010
14								A12	12	A12	111	A12	1011
15								A13	13	A13	112	A13	1012
16								A14	14	A14	113	A14	1013
17								A15	15	A15	114	A15	1014
Sheet2

My look Up Formula Is In Cell A3
In Cell B3 The "Lookup Values" It's The Range From "A1:A9"
In Cell C3 The Data List Including Table 1,2,3 "Table Array"
My Results Of Shoul Be In Cells F3:F11

How Can I Apply This

Thanks In Advance

 

[Domski]

Hi,

I don't really understand the use of A3 and B3 but maybe you could name the table ranges H3:I17, J3:K17, and L3:M17 as Table1, Table2 and Table3 and then use formula:

=VLOOKUP(E3,INDIRECT($C$3),2,FALSE)

in F3 copied down.

Dom

 

[Excel777]

http://www.mrexcel.com/forum/showthread.php?t=424814 Plz Take A look At Original Post This Thread Duplicated With My By Error