| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Function
I am attempting to create a formula that I believe needs to utilize the Match
function. I would like to look at the values in certain cells (every 4th column in a given row) and see if they exceed a certain value and for the first one that does, I would like the result to be what appears in the same column but in a row above. For example, If I had the values 5, 7, 10, 15 in cells A4, E4, I4, and M4 the formula would look for the first instance of a value above 11 (in this case cell M4) and the result would be the conents of cell M1. How would I accomplish this. Thank you in advance for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| MATCH function, exclusion question | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
Threaded Mode
