| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return adjacent cell's value based on formula
I have a formula that returns a result...
=MAX(IF($C$2:$C$14613=N$35,IF($A$2:$A$14613=$L37, $E$2:$E$14613))) How do I return the value of the cell that is located immediately to the left of cell that contains the value produced by the formula above? In other words, if the formula returns a value that is found in cell $C $17, I want to know what value is in cell $C$16. I thought the solution may involve offset(), but I cannot seem to make it return the correct result so I think that is the wrong approach. Any ideas? Thanks! Joseph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to populate data in a cell based on another cell's color | Excel Discussion (Misc queries) | |||
| HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE | Excel Worksheet Functions | |||
| using a cell's reference to return a value. | Excel Worksheet Functions | |||
| CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE | Excel Discussion (Misc queries) | |||
| Change value based on another cell's value | Excel Discussion (Misc queries) | |||
Threaded Mode
