lookup for last matching word in column

[Neat]

Hello guys,

Is it possible to use wildcard with lookup formula?

Regards.

[Pepe Le Mokko]

yes it is possible

[Neat]

Okay I want to lookup for last word as an example "test" in A column but this column also has "besttest" , so the last word in column which contains "test" is "besttest" so how can I do that?

Thank you.

[AliGW]

Try this:

=LOOKUP(2,1/(A2:A10="*test*"),A2:A10)

Adjust the range accordingly.

[Neat]

It Says #N/A

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[Neat]

Here you go

[Bo_Ry]

Please try

=LOOKUP(99,SEARCH("Dixon",A2:A17),A2:A17)

[Neat]

Thank you mate, It's working like a charm!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.