View Single Post
  #2  
Old April 17th, 2009, 05:54 PM posted to microsoft.public.excel.worksheet.functions
Squeaky
external usenet poster
 
Posts: 131
Default vlookup (indirect, or sumproduct) using three tabs

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

Squeaky

"jat" wrote:

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