Hi,
Hendra, thanks for the feedback I'm pleased we could help.
CLR, I haven't seen this before but for limited options this is tidier
than creating a separate lookup table for vlookups.
I like it :-)
Rob Brockett
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=552889