vlookup only part of the string in the cell

[cbubel94]

Hi I'm trying to do a vlookup the problem is the data I pulled is listed as "CAR 1234" and the data I have is "CO-OP #1234"
I am trying to look up just the 1234 part, please help!

A B C D
CO-OP #1234 value I want CAR 1234 VLOOKUP(C,A:B...)

Thanks!
CB

 

[cbubel94]

Hi,



Am Mon, 9 Jun 2014 10:13:49 -0700 (PDT) schrieb (e-mail address removed):







try:

=VLOOKUP("CO-OP #"&MID(C1,FIND(" ",C1)+1,99),$A$1:$B$100,2,0)





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Claus,
Thanks for your help. I'm noticing some of the values are returning N/A because some of the CO-OP #'s will have "CO-OP #1234 (ADDITIONAL WORD OR TWO)"

Is there any way of getting around this?

Thanks again,
CB

 

[Claus Busch]

Hi,

Am Mon, 9 Jun 2014 10:37:55 -0700 (PDT) schrieb (e-mail address removed):

I'm noticing some of the values are returning N/A because some of the CO-OP #'s will have "CO-OP #1234 (ADDITIONAL WORD OR TWO)"

try:
=VLOOKUP("CO-OP #"&MID(C1,FIND(" ",C1)+1,99)&"*",$A$1:$B$100,2,0)

or post some different values that we can see them


Regards
Claus B.

 

[cbubel94]

That worked! Thanks a bunch!!