Thanks Rob.........yeah, it is neat, and of course it's not my
original.........someone taught it to me long ago but I've only recently
started making more use of it..........it can help one over the 7-IF limit
too..........

Vaya con Dios,
Chuck, CABGx3




"broro183" wrote in
message ...

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