Home

Vlookup array where starting column may change

jumpman1500
Occasional Visitor

Hi all, I have template I created which pulls data in from the web. Similarly, I use v-lookups to pull information on separate tabs from the information that I pull in from the web. However, I run into issues because the website I pull the data in from will sometimes changes the formate. For example, the data in column A may move to column B. This causes issues because the vlookup is referencing column A but when that column changes the formula is now referencing the wrong column which was fixed. Is there a way to create a dynamic array in the vlookup formula to combat the formate changes? Also, I am only working with Excel 2010 so some of the newer formulas may not work for me.

 

Thanks in advance! 

1 Reply
Use INDEX-MATCH instead.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies