I am getting a value not available error in excel a lot lately. I tried to solve it but failed miserably. Does anyone know how to correct this error and save my time?
With VLOOKUP, MATCH, LOOKUP, etc. functions the value not available error is associated. It is displayed when a formula is unable to find a referred value. To correct this error, make sure the source data has the lookup value. Try using IFERROR in the formula too. If you still face the error, then you can go to Excel community forum where many people discuss the similar problems.
