yes.. this is exact what i want!! thanks...
can u please explain to me what
<=IF(ISERROR(SMALL(Sheet1!$F:$F,ROWS($A$1:A1))),"" ,INDEX(Sheet1!C:C,MATCH(SMALL(Sheet1!$F:$F,ROWS($A $1:A1)),Sheet1!$F:$F,0)))
means??? so that i can reuse it!!
thanks..
Max Wrote:
"lsy" wrote:
i still not very clear with the solution... what i want is anything
key
in in the col3 with the data with ghi in sheet 1 will auto reflect a
record in sheet2... is that possible??
That's exactly what the suggested construct does !
Here's a sample file with the construct implemented:
http://flypicture.com/p.cfm?id=56960
(Right-click on the link: "Download File"
at the top in the page, just above the ads)
File: lsy_wksht_1.xls
Play with the file. Try adding further to the sample data in Sheet1.
The
results will be updated in Sheet2 automatically.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
--
lsy
------------------------------------------------------------------------
lsy's Profile:
http://www.excelforum.com/member.php...o&userid=23917
View this thread:
http://www.excelforum.com/showthread...hreadid=375546