Display on the cell with a value

K

koba

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
 
K

koba

Thanks

But it did not work because the problem is that the other two cells
have errors in them so functions like max and large need to have whole
numbers, i need a formula that would be able to read errors and then
display to only cell without an error

Andrew
 
B

Biff

If the #N/A's are the result of Vlookups then MAX(............) will reutrn
#N/A.

Biff
 
K

koba

Great thanks for the help!!

Almost there, while this formula displays the number i need which is
good, it displays 0 when all three cells are #N/A, and in this
situation need it to display #N/A or anything but a number!!!

Andrew
 
Top