Dget Function

[Vikram Dhemare]

Hi,
I have two tables, one of them contents database of received material &
other one is the summery of that sheet. The unique field name in both the
sheet is "im_code
" &"im_invrt". Now i wish to pull the latest "im_invrt" from the database
sheet for the given criteria of "im_code" in the summery sheet. I have tried
this by using DGET / DMAX function. but the value returns #NUM!.
Both the sheets are looks like :
Sheet Dbase contents
doc_no im_code im_qty im_invrt date_stmp
GR700144 ATM0093 100 626.02 05/04/2006 07:45:01 AM
GR700147 ATM0093 60 726.02 05/04/2006 07:54:49 AM
GR700148 PTM0748 20 642.72 05/04/2006 07:57:11 AM
GR700152 ATM0093 40 626.02 05/04/2006 09:22:23 AM
GR700185 ATM0762 40 626.02 05/04/2006 06:09:43 PM
GR700193 PTM0748 39 650.72 05/04/2006 06:45:37 PM
GR700185 ATM0762 57 642.72 07/04/2006 04:19:33 PM
And Sheet Summery contents :
im_code im_invrt
ATM0093 =DGET(DBASE!$A$1:$E$8,"IM_INVRT",SUMMERY!$A$1:$A$4)
PTM0748 #NUM!
ATM0762 #NUM!
Is their any solution to pull the latest data (i.e "im_invrt") in the
desired rows.

 

[Anna]

Not pretty sure what you want exactly. You may sort your worksheet first and
let the latest data (i.e "im_invrt") at the last row. You can use macro to
select the last row or the a range of row which fall on the same date
("im_invrt" is the same).

 

[Vikram Dhemare]

What I want is the latest rate from the DBASE sheet for that particular part
would be displayed in the summery sheet (subsequent col. for each part no.).
Is there any excel function something like "GETPIVOTDATA" function.
I don't know much about macros.