Hello, I previously posted (August 24,2022) an issue I was having with needing an Excel formula that would return specific names (in my case vendors) from specific fields. [see "Thread: Excel formula for pulling specific names from fields" by ace8pga8. The formula i ended up using is the following: =IFERROR(LOOKUP(1000,SEARCH($F$4:$F$18,A4),$G$4:$G$18),""). This formula proved very useful with approximately 95% success rate, with the exception that when 2 or more vendors in my lookup vector would pull in the incorrect vendor name. For example if the description field contained 'Microsoft' & 'Teradata', it would return 'Teradata', even though it should be Microsoft. I am attaching two examples in an Excel template that show this occurring. If you will require further data please dont hesitate to ask...
Bookmarks