Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup (indirect, or sumproduct) using three tabs
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup (indirect, or sumproduct) using three tabs
i'm using data validation, list, source is range (for all drop down lists)
jat "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup (indirect, or sumproduct) using three tabs
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct with indirect | Excel Worksheet Functions | |||
SUMPRODUCT & INDIRECT? | Excel Worksheet Functions | |||
Need help with using SUMPRODUCT with INDIRECT | Excel Worksheet Functions | |||
Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
sumproduct & indirect | Excel Worksheet Functions |