A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

vlookup (indirect, or sumproduct) using three tabs



 
 
Thread Tools Display Modes
  #1  
Old April 17th, 2009, 10:51 AM posted to microsoft.public.excel.worksheet.functions
JAT
external usenet poster
 
Posts: 27
Default 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


Ads
  #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


  #3  
Old April 17th, 2009, 08:10 PM posted to microsoft.public.excel.worksheet.functions
JAT
external usenet poster
 
Posts: 27
Default 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  
Old April 17th, 2009, 11:37 PM posted to microsoft.public.excel.worksheet.functions
JAT
external usenet poster
 
Posts: 27
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.