J
jack
I need an if statement that will check two different
columns for text and give me a number result based on
which column has the text in it. The text changes every
week, and there are around ten rows under each column.
Also, there are many occurances of this on the same
spreadsheet. The text could be in any column. The result
can't be based on the actual cell number. I need the
results to be based on example below no matter what column
or row the text is in. I hope this explains it well
enough. The # in () is the result value I need according
to where the text is in columns d and e. Thanks for the
help in advance. Jack
result c d e
need (1) or 2 smith
need 3 or (4) jones
5 or (6) green
columns for text and give me a number result based on
which column has the text in it. The text changes every
week, and there are around ten rows under each column.
Also, there are many occurances of this on the same
spreadsheet. The text could be in any column. The result
can't be based on the actual cell number. I need the
results to be based on example below no matter what column
or row the text is in. I hope this explains it well
enough. The # in () is the result value I need according
to where the text is in columns d and e. Thanks for the
help in advance. Jack
result c d e
need (1) or 2 smith
need 3 or (4) jones
5 or (6) green