Issue with V-lookup and possibly pasting data from the web?
Closed
davidplowman
Posts
5
Registration date
Wednesday April 3, 2013
Status
Member
Last seen
July 8, 2013
-
Apr 15, 2013 at 11:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 16, 2013 at 10:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 16, 2013 at 10:45 AM
Related:
- Issue with V-lookup and possibly pasting data from the web?
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Mint mobile data not working ✓ - Network Forum
- Root directory is full or error in pasting - Android Forum
- Amd data change update new data to dmi ✓ - Windows 10 Forum
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 15, 2013 at 12:12 PM
Apr 15, 2013 at 12:12 PM
Hi DavidPlowman,
Consider uploading your file (www.speedyshare.com) so we can take a better look at your specific case.
Did you put your matrix in alphabetical order?
Best regards,
Trowa
Consider uploading your file (www.speedyshare.com) so we can take a better look at your specific case.
Did you put your matrix in alphabetical order?
Best regards,
Trowa
davidplowman
Posts
5
Registration date
Wednesday April 3, 2013
Status
Member
Last seen
July 8, 2013
Apr 15, 2013 at 12:26 PM
Apr 15, 2013 at 12:26 PM
Trowa:
I'll upload it later this afternoon...
In the meantime, no, my codes are not in any specific order. Would that make a difference? I thought the beauty of Vlookup is so long as the data was in the leftmost column it could be in any order.
Thank you,
David
I'll upload it later this afternoon...
In the meantime, no, my codes are not in any specific order. Would that make a difference? I thought the beauty of Vlookup is so long as the data was in the leftmost column it could be in any order.
Thank you,
David
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
Apr 16, 2013 at 02:01 AM
Apr 16, 2013 at 02:01 AM
Sometimes when you copy from the net, there is a trailing <space> behind or before the word(s). You can trim those that you have copied [=TRIM()]. Anyways, its hard to find the actual reason without seeing some sample. Just trying to share my experience here.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 16, 2013 at 10:45 AM
Apr 16, 2013 at 10:45 AM
Hi David,
You can do a small test to see alphabetical order is important.
Cell reference: Content
A1: b
A2: a
B1: 2
B2: 1
Formula: =VLOOKUP(A2,A1:B2,2)
Result should be 2 but instead you get #N/B.
Now sort data on the first column of the array and the result will be 2.
So sort your data and see if that solves your query.
Best regards,
Trowa
You can do a small test to see alphabetical order is important.
Cell reference: Content
A1: b
A2: a
B1: 2
B2: 1
Formula: =VLOOKUP(A2,A1:B2,2)
Result should be 2 but instead you get #N/B.
Now sort data on the first column of the array and the result will be 2.
So sort your data and see if that solves your query.
Best regards,
Trowa