If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|