Hello Forum,
I need help with a formula that will tell me in what cell was a value found.
I apologies that I cant create a table to display my request. (I am at work)
The value I am looking for is in cell A1
for example if it is the word apple.
I would like to have the formula in B1 and it will tell me
that the word apple is cell E45. (Row E contains the range I am looking thru)
Can someone please help. Thank you
I need help with a formula that will tell me in what cell was a value found.
I apologies that I cant create a table to display my request. (I am at work)
The value I am looking for is in cell A1
for example if it is the word apple.
I would like to have the formula in B1 and it will tell me
that the word apple is cell E45. (Row E contains the range I am looking thru)
Can someone please help. Thank you