Using DGET - Multiple Conditions ??
Hi,
I want to use the DGET command for multiple conditions... ie:
I want to Look for a Specific Product, of Specific Size, and a specific operation, and get this operations corresponding Production value into the cell... The function has to find the values from a Database, contained in a Sheet...
Please see the example file attachmed with this email
http://www.fileden.com/files/2008/4/...cel%20Help.xls
Open Sheet 1....
Is is possible if i could Name a range, from the Product Codes, and save these into the spreadsheet?
Please help/.
Thanks
How about using SuMPRODUCT?
in F24 to F26
=SUMPRODUCT((B24="Elocupid")*($D$3:$J$3=C24)*($C$5:$C$9=D24),$D$5:$J$9)+SUMPRODUCT((B24="Ardropilo")*($D$11:$M$11=C24)*($C$13:$C$17=D24),$D$13:$M$17)
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
I don't think changing the Font size will get better or more help. Please stick to the forum's default font.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
DGET is probably not the function to use in this situation.
DGET works with data that is in Excel's prefered lay-out.
Each row with a unique header and no blank data rows.
Your lay-out with different rows refering to different products is not well suited to DGET.
On Sheet1, does the data relating to each Code/Product Name take up the same number of rows? Does each Code/Product have the same lay-out
Code/Product/Sizes
blank row
5 rows for jobs.
I note that each code might have differing numbers of sizes.
Does each Code have 5 jobs or maybe more or less?
Are the Code blocks arranged in order?
Is there always a blank row below the Code/Product Name?
My approach would be to construct a formula that (given a Code) returned the range of data associated with that code.
Use that as a named range together with an INDEX/MATCH to get the specific data for size and job.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks