Given that Jim Rech took the time to read your first post and I did the
same with your 2nd, the last thing you should be doing is questioning
our patience.

Extend Jim's suggestion to names. Name your table for data on the
ribbon category as 'Ribbon' (w/o the quotes) using Insert | Name
Define... Do the same with the table for 'powder.'

Now, the VLOOKUP(x,INDIRECT(A1),z) will become VLOOKUP(x,Ribbon,z) if
A1 contains Ribbon. XL will interpret the Ribbon reference in the
formula as a range name. Similarly, it will reference the Powder table
if A1 contains 'powder.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I used your technique in creating column A,B and C
I have "Validation" lists to construct the Item description (the 3
parts). So I do have a "NAME"List with the product in A

I beg you to imagine Col. A , B, C with Validation to actually help the
user pick his item. To do that I used the INDIRECT for B to select the
right spec based on A. Exactly as you descripted it but with validation.

My problem is to repeat the SAME TECHNIQUE as you proposed but with
different "Tables" in this case.

So, Col. A has Ribbon ( I have a NAME with the name Ribbon to direct me
to the spec for Ribbon.

NOW How can I used the SAME NAME but point me to TABLE instead of a
validation list; to VLOOKUP it.

In your Formula INDIRECT should use THE SAME name in A1 as a reference
to a table. BUT this A1 points to range name with the same name in order
to create it in the first place using data validation. I know I am
trying very hard to let you visualize the problem. The question is do
you have the patience!!!! I sincerly hope so



*** Sent via Developersdex http://www.developersdex.com ***