Looking to compare 2 Column and find closest match then sort

[skyfleo]

hello , I have this 2 list ,and I want the same word to be in the same row ( Ex : row 1 contains : "Service 351" in A1 and "Service 82" in B1 ) , please help and ty ♥

 

[Fluff]

Using Office 365

The OP is using 2021, which is virtually the same (it just doesn't have Lambda)

 

[Anthony47]

formula has been edited

 

[Anthony47]

The OP is using 2021, which is virtually the same (it just doesn't have Lambda)

Does that version have Let?

 

[Anthony47]

Indeed #Spill implies Dynamic arrays....

 

[skyfleo]

Indeed #Spill implies Dynamic arrays....

 

[Fluff]

Does that version have Let?

Pretty sure it does.

 

[Anthony47]

@skyfleo

I am not able to interpret your message

 

[skyfleo]

I am not able to interpret your message

all I wanted those two columns in left to be like the 2 columns in right

 

[Anthony47]

Supply a sample worksheet where you manually had prepared the wanted output; I cannot imagine how you wish to deal with missing pairs