3 ms·

You really should use MATCH with last argument 0 (exact match) and use it only within IF(ISERROR: IF(ISERROR(MATCH(Key;Keys;0));"null";INDEX(Values, MATCH(Key;

by yread 10y ago

You really should use MATCH with last argument 0 (exact match) and use it only within IF(ISERROR: IF(ISERROR(MATCH(Key;Keys;0));"null";INDEX(Values, MATCH(Key; Keys))))