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. |
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. |
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. |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com