| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to locate the value?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to locate the value?
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) -- Biff Microsoft Excel MVP "Eric" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STILL CAN'T LOCATE XML | New Users to Excel | |||
| Locate Duplicates | Excel Worksheet Functions | |||
| Locate Workbook | Excel Discussion (Misc queries) | |||
| Cannot locate icons ?? | New Users to Excel | |||
| How can I locate the second to last value in a range? | Excel Worksheet Functions | |||
Hybrid Mode
