Forum Discussion
tdonmez17
May 07, 2021Copper Contributor
CANNOT SEE THE COLUMN IS IN WHICH ORDER
Hello, I am working with very big data by using VLOOKUP. While I am choosing the table array, I need to the small notification on the attached photo which I was able to before:....x5C, therefore ...
May 09, 2021
Hi JMB17
could you share sample data, what I can see your are trying to get the column number from the header value. this might be helpful for you.
Make VLOOKUP Column Index Dynamic (Mac & Windows) - https://youtu.be/W8g5jhYV-8M
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.