| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
troubleshoot vlookup returning #N/A
I am trying to troubleshoot a Vlookup formula that inconsistently returns an
N/A#. In one cell where there is no match it correctly returns a zero. Later where there is no match it returns the pesky #N/A. Formula I am using is as follows: =IF(-VLOOKUP(A73,actual,($A$1*2),TRUE)=0,0,-VLOOKUP(A73,actual,($A$1*2),FALSE)) I have tried every combination of true/false in the two vlookup formulas. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
| VLOOKUP help | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Threaded Mode
