Hi All

I need help with a formula, I have 3 cell columns B,C & D with
vlookup’s in each. The way I have set it up so that only one of the
look ups will work. How do then make a formula that will be in column E
and look columns B,C&D and display the only number that has worked

Eg.
A B C D
AT111 #N/A 0.71 #N/A


Please help

Thanks
Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=501901