Hi, I need an index, match formula to return the best possible match. I've attached a worksheet showing exactly what I need. Any help would be appreciated.
The formula would need to look at the postcode in cell B20 then find the best match between B3:AO16. In this case the answer should be LS25 (Cell O6)
Thanks.
Bookmarks