Forum Discussion

NorthernKarsten's avatar
NorthernKarsten
Copper Contributor
Jun 07, 2021

Using vlookup without overwriting values that isnt in the lookup sheet

Hi, im looking to use the vlookup function without overwriting the cells that isnt in the lookup table.  My company have an excelsheet of all the item prices from our factories. When we are getting ...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 07, 2021

NorthernKarsten As a variant, if you are in to a solution that involves Power Query, (PQ) you could have your "overall" worksheet connect to all individual factory price lists. With the right steps within PQ, it achieve the same as VLOOKUP, but without the need to ever have to update formulae.

 

Factory A issues a new price list? Just upload it to the folder with the current price lists for all factories. Open your "overall" sheet and press Refresh All on the Data ribbon. That's it.

 

Something you would like to learn more about? Check out the site in the link below:

https://exceloffthegrid.com/power-query-introduction/ 

Chapter 9, focuses on importing files from a folder. You'll have to go through a learning curve, but I guarantee you that it's worth it.

 

Resources