How to locate the value?

E

Eric

Does anyone have any suggestions on how to locate the value?

There is a table as shown below starting from cell A1

A 4 B 2 C 9 [CELL F1]
V 8 K 0 S 3
J 99 O 8 W 7 [CELL F3]

The given value is S in cell K1
I would like to locate the value on the left hand side of S, which is 3, and
return in cell K2.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
T

T. Valko

I would like to locate the value on the left hand side of S, which is 3

I think you meant on the right side...

As long as "S" is unique:

=SUMIF(A1:E3,"s",B1:F3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the closed value? 7
How to retrieve the value? 3
How to determine the value? 2
How to determine the text? 3
How to locate the error files? 0
locate a cell value within a range and return its reference 0
How to change color within string? 2
How to determine the values? 1

Top