lookups choosing tables

[mojobaabby]

here is what I need to do...
I can do a basic two way look up but I have 30 tables all with different products.
If I create a drop down list with all the tables listed how do I link the drop down to the table look up formula?
All my table have a width row and a height column.
I need users to select the drop down product then enter the width and the height needed to supply the result cell.
Thanks in advance

[NBVC]

Assuming you named each table from top left corner where row headers and column headers intersect to bottom right corner of each table...

Also, Assuming your drop down list selection is in A2 and your vertical value input is in A3 and your horizontal value input is in A4, then try formula:

=INDEX(INDIRECT(A2),MATCH(A3,INDEX(INDIRECT(A2),0,1),0),MATCH(A4,INDEX(INDIRECT(A2),1,0),0))

[mojobaabby]

Ok, I tried the formula (thanks again) using a small table and it worked perfectly with all of my other cells and formulas...I dropped in one of the actual tables (see attached) and no go.
Something I did wrong?

[mojobaabby]

Working now, those darn commas

[NBVC]

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[mojobaabby]

OK ONE MORE ISSUE BECAUSE THERE ARE MULTIPLE LINES ALL NOW NEEDING VALIDATION HOW DO I STOP THE ERROR WHEN THERE IS ONLY ONE ROW BEING USED??
HOPE THIS EXPLAINS AND i HAVE ATTACHED THE EXAMPLE WITH ONE LINE USED
THANKS IN ADVANCE

[NBVC]

Please do not use all caps... it is conceived as shouting!

Also, what am I looking at. Please walk me through the specific issue.

[mojobaabby]

ok here goes best I can
all rows may or may not be used. If i use the first row only to enter information the formulas that I am using to some up and calculate discounts reads the lack of information in the remaining rows as an error and will not function.
I guess what i need is for the remaining calculations to ignore the error, or to have the rows not used to show a zero so the balance of my calculations will work?
Hope that helps

[NBVC]

Perhaps:

Please Login or Register  to view this content.