I need to look up a text in another workbook. WITHOUT VBA, is there a way to lookup a certain text and return what column number it is in?
For example:
A.....B.....C
HI....YO...WHAT UP
<lookup "WHAT UP"> Desired results: 3
The reason I'm doing this is because I have a workbook that will look at various exported data. Sometimes, the column position changes and instead, I want excel to look for the header "amount paid" in the source sheet to give me data.
This won't be a simple case of HLOOKUP either, because I need to match by header and another row criteria.
Thanks in advance!
Bookmarks