What if you are looking for a "begins with"? I.e. the data you are searching for in the leftmost column is ASD1457376, but you only want to look for "ASD"s rather than having to specify all possibilities...
You would use some text manipulation functions to pull three characters from the left of the cell into perhaps a variable and then check that variable. That should do the trick. I don't have sample code off the top of my head but just search for vba text manipulation like the left() function and integrate that into your code.
What if you are looking for a "begins with"? I.e. the data you are searching for in the leftmost column is ASD1457376, but you only want to look for "ASD"s rather than having to specify all possibilities...
Any ideas?
elljaysa 2 years ago
You would use some text manipulation functions to pull three characters from the left of the cell into perhaps a variable and then check that variable. That should do the trick. I don't have sample code off the top of my head but just search for vba text manipulation like the left() function and integrate that into your code.
ExcelisHell 2 years ago
@ExcelisHell
Yep, that helped:
=Vlookup(LEFT(A1,3)etc,etc,2,False)
Cheers!
elljaysa 2 years ago
Glad it helped. For some reason I thought this was a vba tutorial but luckily the functions are similar enough to have helped.
ExcelisHell 2 years ago
Perfect, Thanxs a million this video really helped me :-)
arespinoza85 2 years ago