Can someone please tell me why my VLOOKUP is only working on one row of data in the "Look up" tab?
Can someone please tell me why my VLOOKUP is only working on one row of data in the "Look up" tab?
Hi,
vlookup is working well, it does not find the exact matches because data in column A of datasource are not equal to data of sheet lookup .
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thats because BR5A_CL01\05\05 is the only value that can be found in the 'data' range
In addition to BR5A_CL01\05\05 there is only one value beginning with BR5A_CL01\05\ i.e. BR5A_CL01\05\15
Life's a spreadsheet, Excel!
Say thanks, Click *
OM gosh. I feel like a douche! Copied the wrong identifiers in. Sorry for wasting your time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks