Just tinkering around ..
Assuming this is in B3:E5
10/01/01 10/08/05
1354 -1.5 0
1469 25 "blank cell"
1568 33,000 40,000
and if we have:
in A8: 1469
in B7: 10/08/05
Putting in say, B8:
=IF(ISBLANK(INDIRECT(
ADDRESS(MATCH(A8,A:A,0),MATCH(B7,2:2,0)))),"",
INDIRECT(ADDRESS(MATCH(A8,A:A,0),MATCH(B7,2:2,0))) )
seems to return the desired result, i.e. blank
Changing the input in A8 to say: 1354
would return in B8: 0, and so on ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--