I have come across the function FUZZYPERCENT which nearly does what I am after.
Does anyone know of a version of FUZZYPERCENT which works in a similar way to FUZZYVLOOKUP and so will look up a Value against a Table Array instead of a String.
Thank you.
Bookmarks