| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with DGET function
I have a workbook with the following two worksheets and associated columns:
Sheet1 Column A = Factory ID Column B = Department ID Column C = Part ID Sheet2 Column D = Factory ID Column E = Department ID Column F = Department Name Column G = Part ID I would like to use the DGET function (as opposed to using VBA) to obtain the Part ID from Sheet1 and automatically populate the same field (column G) on Sheet2 based on a user first inputting the Factory ID and Department ID on Sheet2. Can this be done? Thanks in advance for any help. Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with DGET function
Hi,
You may use this formula. A3:C8 contains the data on sheet 1. row 3 is the header row. E4 has Part ID (this should be spelled the same way as the Part ID on sheet1). Sheet2!B4:C5 contains the headers and the criteria =DGET(Sheet1!$A$3:$C$8,Sheet2!E4,Sheet2!B4:C5) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... I have a workbook with the following two worksheets and associated columns: Sheet1 Column A = Factory ID Column B = Department ID Column C = Part ID Sheet2 Column D = Factory ID Column E = Department ID Column F = Department Name Column G = Part ID I would like to use the DGET function (as opposed to using VBA) to obtain the Part ID from Sheet1 and automatically populate the same field (column G) on Sheet2 based on a user first inputting the Factory ID and Department ID on Sheet2. Can this be done? Thanks in advance for any help. Bob |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with DGET function
Ashish,
Thanks for your help. However, I know how to use DGET. What I was looking for was a solution that would allow me to use "rolling" (for lack of a better term) criteria. Your solution is for a single row of data. I deliberately described my problem in terms of columns because I need to somehow vary the criteria so that it points to the Factory ID and Department ID on Sheet2 for each and every row that contains these two data elements. I don't know if such a solution is possible, so I reached out to this Discussion Forum to see if such a solution existed. Bob "Ashish Mathur" wrote: Hi, You may use this formula. A3:C8 contains the data on sheet 1. row 3 is the header row. E4 has Part ID (this should be spelled the same way as the Part ID on sheet1). Sheet2!B4:C5 contains the headers and the criteria =DGET(Sheet1!$A$3:$C$8,Sheet2!E4,Sheet2!B4:C5) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... I have a workbook with the following two worksheets and associated columns: Sheet1 Column A = Factory ID Column B = Department ID Column C = Part ID Sheet2 Column D = Factory ID Column E = Department ID Column F = Department Name Column G = Part ID I would like to use the DGET function (as opposed to using VBA) to obtain the Part ID from Sheet1 and automatically populate the same field (column G) on Sheet2 based on a user first inputting the Factory ID and Department ID on Sheet2. Can this be done? Thanks in advance for any help. Bob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with DGET function
Hi,
You cannot do that with the DGET. Is the Part ID a numeric field -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... Ashish, Thanks for your help. However, I know how to use DGET. What I was looking for was a solution that would allow me to use "rolling" (for lack of a better term) criteria. Your solution is for a single row of data. I deliberately described my problem in terms of columns because I need to somehow vary the criteria so that it points to the Factory ID and Department ID on Sheet2 for each and every row that contains these two data elements. I don't know if such a solution is possible, so I reached out to this Discussion Forum to see if such a solution existed. Bob "Ashish Mathur" wrote: Hi, You may use this formula. A3:C8 contains the data on sheet 1. row 3 is the header row. E4 has Part ID (this should be spelled the same way as the Part ID on sheet1). Sheet2!B4:C5 contains the headers and the criteria =DGET(Sheet1!$A$3:$C$8,Sheet2!E4,Sheet2!B4:C5) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... I have a workbook with the following two worksheets and associated columns: Sheet1 Column A = Factory ID Column B = Department ID Column C = Part ID Sheet2 Column D = Factory ID Column E = Department ID Column F = Department Name Column G = Part ID I would like to use the DGET function (as opposed to using VBA) to obtain the Part ID from Sheet1 and automatically populate the same field (column G) on Sheet2 based on a user first inputting the Factory ID and Department ID on Sheet2. Can this be done? Thanks in advance for any help. Bob |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with DGET function
Ashish,
I didn't think so, but I though I would ask anyway. The Part ID is a numeric field. Thanks for your help, Bob "Ashish Mathur" wrote: Hi, You cannot do that with the DGET. Is the Part ID a numeric field -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... Ashish, Thanks for your help. However, I know how to use DGET. What I was looking for was a solution that would allow me to use "rolling" (for lack of a better term) criteria. Your solution is for a single row of data. I deliberately described my problem in terms of columns because I need to somehow vary the criteria so that it points to the Factory ID and Department ID on Sheet2 for each and every row that contains these two data elements. I don't know if such a solution is possible, so I reached out to this Discussion Forum to see if such a solution existed. Bob "Ashish Mathur" wrote: Hi, You may use this formula. A3:C8 contains the data on sheet 1. row 3 is the header row. E4 has Part ID (this should be spelled the same way as the Part ID on sheet1). Sheet2!B4:C5 contains the headers and the criteria =DGET(Sheet1!$A$3:$C$8,Sheet2!E4,Sheet2!B4:C5) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... I have a workbook with the following two worksheets and associated columns: Sheet1 Column A = Factory ID Column B = Department ID Column C = Part ID Sheet2 Column D = Factory ID Column E = Department ID Column F = Department Name Column G = Part ID I would like to use the DGET function (as opposed to using VBA) to obtain the Part ID from Sheet1 and automatically populate the same field (column G) on Sheet2 based on a user first inputting the Factory ID and Department ID on Sheet2. Can this be done? Thanks in advance for any help. Bob |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with DGET function
Hi,
You could use this formula in column G of sheet2 =sumproduct((sheet1!$A$3:$A$100=D3)*(sheet1!$B$3:$ B$100=E3)*(sheet1!$C$3:$C$100)) Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... Ashish, I didn't think so, but I though I would ask anyway. The Part ID is a numeric field. Thanks for your help, Bob "Ashish Mathur" wrote: Hi, You cannot do that with the DGET. Is the Part ID a numeric field -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... Ashish, Thanks for your help. However, I know how to use DGET. What I was looking for was a solution that would allow me to use "rolling" (for lack of a better term) criteria. Your solution is for a single row of data. I deliberately described my problem in terms of columns because I need to somehow vary the criteria so that it points to the Factory ID and Department ID on Sheet2 for each and every row that contains these two data elements. I don't know if such a solution is possible, so I reached out to this Discussion Forum to see if such a solution existed. Bob "Ashish Mathur" wrote: Hi, You may use this formula. A3:C8 contains the data on sheet 1. row 3 is the header row. E4 has Part ID (this should be spelled the same way as the Part ID on sheet1). Sheet2!B4:C5 contains the headers and the criteria =DGET(Sheet1!$A$3:$C$8,Sheet2!E4,Sheet2!B4:C5) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bob" wrote in message ... I have a workbook with the following two worksheets and associated columns: Sheet1 Column A = Factory ID Column B = Department ID Column C = Part ID Sheet2 Column D = Factory ID Column E = Department ID Column F = Department Name Column G = Part ID I would like to use the DGET function (as opposed to using VBA) to obtain the Part ID from Sheet1 and automatically populate the same field (column G) on Sheet2 based on a user first inputting the Factory ID and Department ID on Sheet2. Can this be done? Thanks in advance for any help. Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question using DGET function | Excel Worksheet Functions | |||
| DGET Function + External data from another excel file | Excel Worksheet Functions | |||
| Dget Function | Excel Discussion (Misc queries) | |||
| DGET FUNCTION | Excel Discussion (Misc queries) | |||
| dget function | Excel Worksheet Functions | |||
Hybrid Mode
