LinkBack URL
About LinkBacks
I can do a simple vlookup but would like to know if it can look at the last or first few characters... if it is possible then what function would I need to add to the Vlookup so it can look for a specific match on the 1st or last few characters???
I can do a simple vlookup but would like to know if it can look at the last or first few characters... if it is possible then what function would I need to add to the Vlookup so it can look for a specific match on the 1st or last few characters???
Last edited by jgomez; 11-04-2011 at 11:49 AM.
It depends on exactly what you want to match?
If you use a lookup value of LEFT(A2,1)&"*" within VLOOKUP...
...for example then if A2 contains "xyz" that would match with anything beginning with an "x"......or you can use the LEFT part on it's own to match with "x" exactly. You can do the same with RIGHT
Audere est facere
I get #N/A. I have 123123 in cell A2 & 12 in cell c2.... this is my formula
=VLOOKUP(LEFT(C2,2)&"*",A:A,1,FALSE)
The formula will only work when comparing text. In a numeric sense, the '12' at the start of 121212 is actually 120,000.
If you convert your numbers to text the formula should work fine.
Thank you both! Adjusted the formula a bit too though
=VLOOKUP(LEFT(C$1,2)&"*",A1,1,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks