You're welcome. Glad to hear that you got it working.
Biff's suggested formula works just as well (and is shorter!)
Maybe try copy pasting his formula again into C1
- it works fine here.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"a" wrote in message
...
tHANK YOU MAX AND BIFF
- i was able to resolve the problem with the index solution suggested by
max..and it worked fine...... the vlook formula returned an erroe
message......regards,