Retrieving info from multiple tables

P

PMaravy

I have a worksheet with three Tables (Table1, Table2, and Table3), 10 rows by
5 Columns.

In cell A1, List: Table1, Table2 and Table3

In cell B1, List: A, B, C, D, E, F, G, H, I, J (First Column in each table)

In cell B2, VLOOKUP(B1,A1,2) (Looking for the value in the 2nd Column
depending on which table I choose in cell A1) Repeat B3, B4, B5 Column
increase by 1 for VLOOKUP
Problem is VLOOKUP will not allow a cell such as A1, it wants one table name.

The Tables will be hidden

Respectfully,
Paul M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Help 5
VLOOKUP...have 3pm deadline but making progress almost there! 6
Skip Reference Sequences during copy 3
Convert text in cell to a range name for formula 1
Using Multiple LOOKUP tables 3
How can I paste in the opposite direction? 12
Formula Content linked to other cells formula Content 5
JOIN issue: Valid Syntax to refer to (In FROM clause) the Selected Fields from Query 15

Top