Vlookup !
Try this:
In sheet 2
A2: holds criteria
Date
B2: =LOOKUP(2,1/(Name=A2),Date)
Amount
C2: =LOOKUP(2,1/(Name=A2),Amount)
"Tufail" wrote:
Hello All,
I am looking some following solution :
Sheet1 Table :
Col_A (Date) Col_B (Name) Col_C (Amt)
01-Jan-2009 Japan 1500
02-Jan-2009 Singapore 2000
05-Jan-2009 Singapore 1700
06-Jan-2009 Japan 1000
10-Jan-2009 Korea 1500
Now I want get in Sheet2 just last date & Pmt Amt like as under :
Japan 06-Jan-2009 1000
Singapore 05-Jan-2009 1700
Is it possible ?
Thanks in advance.
|