Forum Discussion
VLOOKUP Formulas stopped working
Hi! I have two files that are linked. They are linked with a VLOOKUP formula. They have been working until this week. I'm trying to find the reason the VLOOKUP formula doesn't work anymore. When...
Hi, again! It is set to automatic, but it still doesn't work. How do I check the link?
Hello Im having the same error, did you find a way to fix it ?
- Hello TRichardson35 and MP2121212121
If it is possible move to the new XLOOKUP version. It is better than the old VLOOKUP.
When you say "... doesn't work anymore..." what do you mean? is the VLOOKUP returning the wrong value? Is it not returning any values? Is it returning the same value for all instances?
Somethings to look for are:
Has any columns been added in the table array? For example if you are searching in column A, and returning values from column B has a column been inserted such as column B is now column C?
Is the table array sorted?
Let us know so that we can help you more. If this is resolved please let us know as well.
