Correct Value Not Available Error In A Jiffy.

Asked By Jamie de Jesus 0 points N/A Posted on - 04/29/2017

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?

• Status: Open
• Question Views: 434
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: OS
• Question Tags: Error | OS

Answered By Greg Lewis 40 points N/A #295965

Correct Value Not Available Error In A Jiffy.

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.

About Greg Lewis

Questions
44

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/29/2017
• Question Category: OS