vlookup (indirect, or sumproduct) using three tabs

[jat]

i have a purchase order using three tabs.

Sheet1:
Cell A1 has a supplier name (is a drop down list based on a list from Sheet2.
Cell A5 is a product code and is a drop down list based on a list from Sheet3
Cell A6 ... (this cell needs to get the description from Sheet3, and is
dependent on cell A5 and A1...)

Sheet2:
ColumnA is the supplier name (this is the dropdown list in Sheet1, Cell A1)
ColumnB is a short name for the supplier or a supplier code

Sheet3:
ColumnA has the supplier code
ColumnB has the Product Code (this is drop down list that is on Sheet1 Cell A5
ColumnC has the appropriate description for the Product or Item for that
Particular Supplier

On Sheet1 Cell A6, to retrieve the description, i have tried an indirect
vlookup (that is what i was using on my last po,) but that does not work. i
also have a sumproduct that works on another spreadsheet, but when i rework
it for this sheet it does not want to work.

now i'm stuck and i'm back again...

any suggestions would be appreciated.

jat

 

[Squeaky]

What type of drop down boxes are you using? Active X control or Forms?

Squeaky

 

[jat]

i'm using data validation, list, source is range (for all drop down lists)

jat

 

[jat]

i have part of the solution and have started a new subject, see "need
sumproduct to return text values..." and i have a partial working sumproduct
formula that sort of works but not quite and what i am looking for.

thank you,

jat