On Nov 4, 10:24*pm, Mel wrote:
I have a spreadsheet that has 8 seperate tables that do a
calculation. *If the input option matches one of the 8, a value will
be displayed, if not, 'False' will be displayed. * What I am trying to
do is look at all 8 fields and the one that is not equal to 'false',
show that value.

field to display in is M8. *Fields with the data a U8, AN8, BA8,
BN8, CA8, CN8, DA8, DN8.
I will be copying this formula down for the forty rows below. (M8 to
M47).

I have tried "If(and" and "if(or" but cannot get past the first 3.

I know there has to be an easier way.
thx

Mel

Hello Mel,

I'm not really clear what you want to do. What value is in M8, can you
give an example. Are you looking for a match with one of those 8
cells. If M8 = BA8 for instance then what value would you like to
return?

regards, barry