Help with XLOOKUP

[JARichard74]

=XLOOKUP(LEFT(Price!A4,3)&”*”,All!$R$1:$BA$1,XLOOKUP(Price!$A$3,All!$I$3:$I$8,OFFSET(All!$R$3:$BA$8,0,6)),,2)

Formula works as designed if Price!A4 is an exact match to one of the values in All!$R$1:$BA$1. The problem I am trying to solve is that the Value Price!A4 is not an exact match e.g. Price!A4=GoldenLabradorRetriver while lets say All!$R$1 = Golden Labrador Retriever

 

[jasonb75]

Allowing for spelling errors etc would need fuzzy matching, something that excel functions do not support. There are a few options that may work but the solution would be to use data validation to ensure that the entries are an exact match.

 

[JARichard74]

Allowing for spelling errors etc would need fuzzy matching, something that excel functions do not support. There are a few options that may work but the solution would be to use data validation to ensure that the entries are an exact match.

Thanks. It actually works. I noticed the quotes around the * did not look right. The concern I have is if more than one entry has the same first 3 left characters then it would not work. I will look into data validation