If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to determine the values?
Does anyone have any suggestions on how to determine the value?
For example, Under following columns: [A] [b] [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 |
#2
|
|||
|
|||
How to determine the values?
Try this array formula** :
=MAX((B13=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. -- Biff Microsoft Excel MVP "Eric" wrote in message ... Does anyone have any suggestions on how to determine the value? For example, Under following columns: [A] [b] [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 |
Thread Tools | |
Display Modes | |
|
|