Hello guys,
Is it possible to use wildcard with lookup formula?
Regards.
Hello guys,
Is it possible to use wildcard with lookup formula?
Regards.
yes it is possible
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.
Try this:
=LOOKUP(2,1/(A2:A10="*test*"),A2:A10)
Adjust the range accordingly.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It Says #N/A
Last edited by AliGW; 05-02-2020 at 08:24 AM. Reason: Please don't quote unnecessarily!
There are instructions at the top of the page explaining how to attach your sample workbook.
Here you go
Please try
=LOOKUP(99,SEARCH("Dixon",A2:A17),A2:A17)
Thank you mate, It's working like a charm!
Last edited by AliGW; 05-02-2020 at 12:33 PM. Reason: Please don't quote unnecessarily!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks