Forum Discussion

ravi0408's avatar
ravi0408
Copper Contributor
Aug 22, 2022
Solved

Prefix Name Match with starting name along with added suffixes characters.

Hi,   i have a list of some names and thier new name replacement data. I want to lookup in a range where the real name have some added suffixes characters.   Is there any formula which can be typ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Aug 22, 2022

    ravi0408 

    How about

    =XLOOKUP(1,XMATCH($A$3:$A$10&"*",D3,2),$B$3:$B$10,"")

    in E3, the fill down.

ravi0408's avatar
ravi0408
Copper Contributor
Aug 22, 2022
That's not working. i want full name to be matched avoiding suffix from sample name then replace with new name.

Also see the latest example sheet to gain more in the problem.

Thanks
HansVogelaar's avatar
HansVogelaar
MVP
Aug 22, 2022

ravi0408 

How about

=XLOOKUP(1,XMATCH($A$3:$A$10&"*",D3,2),$B$3:$B$10,"")

in E3, the fill down.

  • ravi0408's avatar
    ravi0408
    Copper Contributor
    Aug 23, 2022
    Thanks. this works well.

Resources