i'm trying to do i Vlookup
but i'm looking up for example
50212 but where i'm trying to find it, it looks like this
50212sd-23-2-09
is there anyway i can do
=vlookup(a2, (left, 5) A5-C5, 3, false)
Also is it possible to put a count in so it counts how many characters are in the original cell like 50212 is 5 and how do i put this in the Vlookup?
=vlookup(a2, (left, (count, a2) A5-C5, 3, false)
is there anyway to get an exact match. as i've use the wildcard and i've had
450212 and it found that rather than 50212?
Thanks for any help you can give![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=64></TD></TR></TBODY></TABLE>
but i'm looking up for example
50212 but where i'm trying to find it, it looks like this
50212sd-23-2-09
is there anyway i can do
=vlookup(a2, (left, 5) A5-C5, 3, false)
Also is it possible to put a count in so it counts how many characters are in the original cell like 50212 is 5 and how do i put this in the Vlookup?
=vlookup(a2, (left, (count, a2) A5-C5, 3, false)
is there anyway to get an exact match. as i've use the wildcard and i've had
450212 and it found that rather than 50212?
Thanks for any help you can give
<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=64></TD></TR></TBODY></TABLE>