If I have a store number (say 1234) and I am trying to search for something which contains 1234 (i.e. the whole string of ABCD1234, ABCD1235, ABCD1236 etc) is it possible to do this in one VLOOKUP formula?
One way of doing it would be to VLOOKUP("ABCD"&"1234",....) but I would rather do it the other way around, to prevent the formula from not working.
Last edited by tangcla; 11-17-2008 at 11:17 PM.
Try something like:
=VLOOKUP("*1234",....)
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.
I should also have added that 1234 will be a cell reference - so *A2 won't work.Originally Posted by NBVC
However, I was playing with it, and "*"&A2 works...!
Last edited by tangcla; 11-17-2008 at 11:23 PM. Reason: Silly typo
That would be "*"&A2
Err yes that's what I meant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks