| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I avoid #NA result in a VLOOKUP
I am trying to vlookup a number stored as text. I have verified and
reverified the formula nothing seems to be wrong, the syntex is correct and the field references are correct, but it keeps returning for all cells #NA. How to debug this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| VLOOKUP - Can't see result | Excel Worksheet Functions | |||
| vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
| How to avoid the #Value! result in a formula? | Excel Worksheet Functions | |||
![VKL Narayanan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
