Using DGET - Multiple Conditions ??

**rohit475** · 05-30-2009, 07:23 AM

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

**Special-K** · 05-30-2009, 09:58 AM

How about using SuMPRODUCT?

in F24 to F26

Please Login or Register  to view this content.

**royUK** · 05-30-2009, 11:25 AM

I don't think changing the Font size will get better or more help. Please stick to the forum's default font.

**mikerickson** · 05-30-2009, 09:25 PM

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.