Find column number based on text
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?
<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!
Got answer on first post:
Kudos to Domenic.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1