Forum Discussion
Which text function to use to look up name in different coloums with different layout
Himathetes
Thank for you quick reply and input. I'm gonna try what you suggested. I attached an example of the file.
What I need to check is the names in sheet1 are also in sheet2 if so, than I need to lookup the value that is in Sheet2 column C. Maybe this brings up some more ideas. 🙂 Appreciate your help thank you.
Changed your Sheet2 into a structured table to make the formula more dynamic. Extend the table and the formulae will follow. The looking up of partial names is done by INDEX and SEARCH, but it only finds the first occurrence of the name. It can NOT differentiate between "A. Smith" and "B. Smith" based only on a search for "Smith".
So, it might not be useful. But perhaps it will. See attached!
Thanks a lot Riny_van_Eekelen! I'm gonna try this and see if it helps me.