Partial Matching HELP NEEDED...SOS!!

  • Thread starter Thread starter MikeMikeMike
  • Start date Start date
M

MikeMikeMike

I am struggling with this and wondering if you could help..

Worksheet 1 Column A & B
Keyword Category
telecom Telecom
tele com #N/A

Worksheet 2 Column A & B
term category
telecom Telecom
telcom Telecom
tele com Telecom

What I want to do is pull the category name from worksheet 2 on to
worksheet 1.

=VLOOKUP("*"&A2&"*",Sheet1!B:B,1,0)

Is not working...any ideas?
 
MikeMikeMike said:
I am struggling with this and wondering if you could help..

Worksheet 1 Column A & B
Keyword Category
telecom Telecom
tele com #N/A

Worksheet 2 Column A & B
term category
telecom Telecom
telcom Telecom
tele com Telecom

What I want to do is pull the category name from worksheet 2 on to
worksheet 1.

=VLOOKUP("*"&A2&"*",Sheet1!B:B,1,0)

Is not working...any ideas?
Click to expand...


Try:

=VLOOKUP("*"&A2&"*",Sheet1!A:B,2,0)

(Unless you mean Sheet2 ... your explanation and formula didn't seem to
match.)
 
Back
Top