How to determine the values?


E

Eric

Does anyone have any suggestions on how to determine the value?
For example,
Under following columns:
[A] [C] [D]
1 174 198 222
7 180 204 228
9 182 206 230

A given number is 204 in cell E1, I would like to determine the value under
column A, which should return 7, because 204 is under the same row.

A given number is 174 in cell E1, I would like to determine the value under
column A, which should return 1, because 174 is under the same row.

Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric
 
Ad

Advertisements

T

T. Valko

Try this array formula** :

=MAX((B1:D3=E1)*A1:A3)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 

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

Top