Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Function returning #N/A error for two entries
I have a Vlookup formula that is pulling data from a download. The formula
works perfect except when it gets to two project number. But when it gets to a couple particular project numbers the formula does not pull the applicable amount. But if I copy the same exact project names and paste it. Then the formula works. Is there a reason that this occurs when using Vlookup formulas? Is there a way to fix this? It so odd because all the other project numbers work and the amount is pulled once the project number is found in the list. But these two project numbers return a #N/A error until I copy the project number. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Function returning #N/A error for two entries
Could there perhaps be a space in front of the project numbers that are
failing? Perhaps they are formatted differntly? "rtjeter" wrote: I have a Vlookup formula that is pulling data from a download. The formula works perfect except when it gets to two project number. But when it gets to a couple particular project numbers the formula does not pull the applicable amount. But if I copy the same exact project names and paste it. Then the formula works. Is there a reason that this occurs when using Vlookup formulas? Is there a way to fix this? It so odd because all the other project numbers work and the amount is pulled once the project number is found in the list. But these two project numbers return a #N/A error until I copy the project number. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Function returning #N/A error for two entries
There does not appear to be a space in front of the project numbers. It's so
odd that the formula isn't working properly for those two project numbers. "tim m" wrote: Could there perhaps be a space in front of the project numbers that are failing? Perhaps they are formatted differntly? "rtjeter" wrote: I have a Vlookup formula that is pulling data from a download. The formula works perfect except when it gets to two project number. But when it gets to a couple particular project numbers the formula does not pull the applicable amount. But if I copy the same exact project names and paste it. Then the formula works. Is there a reason that this occurs when using Vlookup formulas? Is there a way to fix this? It so odd because all the other project numbers work and the amount is pulled once the project number is found in the list. But these two project numbers return a #N/A error until I copy the project number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Help with VLookup function | Excel Worksheet Functions | |||
Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
VLOOKUP Function | Excel Discussion (Misc queries) |