May 07 2021 02:04 AM
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 I was writing 5:0 on the VLOOKUP formula. But now I cannot count everytime the last column that I marked is in which order like A B C ... X Y Z. How can I make it this notification appear again?
May 08 2021 02:42 PM
Hi @tdonmez17,
Sorry, I was not able to catch up with your query, could you please attached a sample file with the annotating your issue
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.
May 08 2021 06:50 PM
May 09 2021 02:12 PM
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.
May 09 2021 03:26 PM
May 16 2021 02:32 PM