|
Posted to microsoft.public.excel.misc
|
|
|
Excel Issue
THANKS A TON MAX !!!!
"Max" wrote:
It's working fine Max,
Good to hear that
.. but is there any other way to do this ????
Since index/match gives you the flexibility mentioned earlier, which
addresses the intent underlying your original posting, what more could you
possibly be after, I wonder?
You could copy the top cell formula down to do it correspondingly for all
values. And you could use an IF(ISNA(..) error trap to return neat looking
blanks: "" for any unmatched cases, like this:
=IF(ISNA(MATCH(A1,Sheet2!B:B,0)),"",INDEX(Sheet2!A :A,MATCH(A1,Sheet2!B:B,0)))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
|