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