Vlookup Technique Help

This is a discussion on Vlookup Technique Help within the Excel Questions forums, part of the Question Forums category; Hey, Plz Need Help In This Loopup Technique Sheet2 &#160; A B C D E F G H I J ...

1. Vlookup Technique Help

Hey,
Plz Need Help In This Loopup Technique

Sheet2

 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

 Cell Formula A3 =VLOOKUP(B3,C3,2,0)

Excel tables to the web >> Excel Jeanie HTML 4

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

2. Re: Vlookup Technique Help

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

3. Re: Vlookup Technique Help

Vlookup Technique Help Plz Take A look At Original Post This Thread Duplicated With My By Error

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•