Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a formula that looks like this:
=INDEX($E$21:$W$35,MATCH($B40,$B$21:$B$35,0),0) I want to wrap a Min formula around the result of value that arises from the formaul and another cell E38: =Min(E38, INDEX($E$21:$W$35,MATCH($B40,$B$21:$B$35,0),0)) However, when I do this, it seems to produce a value that is neither E38 nor the value from the Index. It seems to be pulling a value from the array within the index. Can I wrap something around the index to ensure that only the values from E38 and the Index are included in the calc. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula returning #N/A | Excel Worksheet Functions | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How to use a table index from a formula | Excel Worksheet Functions |