Just wasted 30 mins in excel to work out the LOOKUP function is returning inaccurate data because it’s looking for approximate matches.
Just wasted 30 mins in excel to work out the LOOKUP function is returning inaccurate data because it’s looking for approximate matches.