Forum Discussion
dumdiddydumdum
Apr 14, 2022Copper Contributor
vlookup na
is anyone able to point out why my lookup isnt working? I have made sure format for all referenced cells is the same, tried with false and true arguments for exact and approximate matches and tried...
HansVogelaar
Apr 14, 2022MVP
143.031 is the maximum value in J36:J52, so that should be the first column in the lookup range:
=VLOOKUP(N55, J36:K52, 2, FALSE)