Forum Discussion
Solved
max corresponding to a value which may be in 1 or multiple sets
Hi G6 is showing error because F6 is not found in D15:D50. what would be the simple process that F6 is searched in D15:D50 and D56:D91 and returns value from col K instead of an error whether or not...
That formula should work, provided that your objective to find an exact match of -917 in both ranges for column D. There is no match in both you'll get #N/A.
Use the optional argument [march_mode] to indicate your intentions is an exact match is not found as illustrated in the screenshot below.
That formula should work, provided that your objective to find an exact match of -917 in both ranges for column D. There is no match in both you'll get #N/A.
Use the optional argument [march_mode] to indicate your intentions is an exact match is not found as illustrated in the screenshot below.