Greater Than Or Equal To Matching Test. The gist would be if f2 is less. Let us use the comparison operator “greater than or equal to” with the if condition if condition if function in excel.
Nearest Match Greater Than or Equal to Search Key in Vlookup from infoinspired.com
I have gathered from other posts that an index match is probably the correct way to go, but being a vlookup user i can't quite get. 9 quick ways to apply ‘if greater than’ in excel 1. 2 is greater than or equal to 1 2 is greater than or equal to 2 test:
