Hi,
For some datas like,C-D1883,L-E2314 Vlookup is not working
I these case after the '-', a alphabet is coming.
In this cases 'VLookup' not working.
What will i do in these cases.
Please reply
Thanks,
Eler
Hi,
For some datas like,C-D1883,L-E2314 Vlookup is not working
I these case after the '-', a alphabet is coming.
In this cases 'VLookup' not working.
What will i do in these cases.
Please reply
Thanks,
Eler
Please post your formula so we'll see what you're working with.
VLookup(C-D1883, B2:F2334, 4, True)
This is the formula.I want to retreive the data in the 4th column.
Regards,
Eler
The Vlookup value should probably be in quotes as such....
=VLookup("C-D1883", B2:F2334, 4, True)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Your VLOOKUP has a final argument of TRUE. If you only want an exact match change to FALSE. If you leave the formula as it is B2:B2334 should be sorted ascending
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks