Vlookup array where starting column may change

Copper Contributor

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.