Support Board
Date/Time: Tue, 26 Nov 2024 10:20:26 +0000
Post From: Compare range of individual values
| [2023-12-12 07:18:09] |
| User273277 - Posts: 58 |
|
I got index with nmatch to work with a static value. It looks like nmatch requires a static value paramater and does not accept a cell reference? ie. =INDEX(O4:O54,NMATCH(1,4678.1875,P4:P54,0),1) I need to do something like: =INDEX(O4:O54,NMATCH(1,O4,P4:P54,0),1) I need to enter a cell reference of O4 instead of the static 4678.1875. Is there another way to do this? Date Time Of Last Edit: 2023-12-12 07:20:12
|