Glad you like this formula.

It has been a favorite of mine for many years...

Just remember that it will fail if the item isn't in the lookup list...l

--
steveB

Remove "AYN" from email to respond
"Optitron" wrote in
message ...

Ah very nice. I was using a Lookup formula =LOOKUP(A1,C:C,D:D) but it
had to be alphabetized. Thank you.


--
Optitron
------------------------------------------------------------------------
Optitron's Profile:
http://www.excelforum.com/member.php...o&userid=26729
View this thread: http://www.excelforum.com/showthread...hreadid=466531