Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 698
- Office Version
- 2010
- Platform
- Windows
Hi:
I am using VLOOKUP to pull data from one list into another list but VLOOKUP returns #NA. When I manually copy and paste lookup value from one list into the other list, VLOOKUP returns required value. I have cleaned up both list using TRIM(CLEAN), but VLOOKUP still returns #NA. I have also used Power Query to transform lists, but VLOOKUP still returns #NA. Lookup values are the same on both list – I doubled checked it. Again, when I copy and paste lookout value from one list into the other list, VLOOKUP returns required value. What else can I do to remedy this?
Regards,
S
I am using VLOOKUP to pull data from one list into another list but VLOOKUP returns #NA. When I manually copy and paste lookup value from one list into the other list, VLOOKUP returns required value. I have cleaned up both list using TRIM(CLEAN), but VLOOKUP still returns #NA. I have also used Power Query to transform lists, but VLOOKUP still returns #NA. Lookup values are the same on both list – I doubled checked it. Again, when I copy and paste lookout value from one list into the other list, VLOOKUP returns required value. What else can I do to remedy this?
Regards,
S