JBARR

Thanks for the reply!

Did exactly like you've suggested.
Unfortunately, looks like it doesn't work as it is supposed to...

http://img56.imageshack.us/img56/7852/clipboard13tu.jpg

I guess the VLOOKUP function works the same way as MATCH - it returns
the referrence based on the first matching value, ignoring all others
:(

Take a look at the screenshot I've included. Maybe I'm doing something
wrong there?


--
Landanan
------------------------------------------------------------------------
Landanan's Profile: http://www.excelforum.com/member.php...o&userid=31262
View this thread: http://www.excelforum.com/showthread...hreadid=509352