VLOOKUP Help

[pandyav]

Can someone please help with this?

I have data in two separate worksheets:

Worksheet A: Column A has 'Mayo Medical Labs'
Worksheet B: Column A has 'Mayo medical labs Incorporated'

I only want to match the first word between the cells in worksheet A and B.
Is there a way to add 'Mayo medical labs Incorporated' in column B in Worksheet A by using VLOOKUP.

Appreciate your help in advance.

 

[Aladin Akyurek]

Can someone please help with this?

I have data in two separate worksheets:

Worksheet A: Column A has 'Mayo Medical Labs'
Worksheet B: Column A has 'Mayo medical labs Incorporated'

I only want to match the first word between the cells in worksheet A and B.
Is there a way to add 'Mayo medical labs Incorporated' in column B in Worksheet A by using VLOOKUP.

Appreciate your help in advance.

Try...

=VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",'Worksheet B'!A:A,1,0)

 

[NBVC]

Try

=INDEX('SheetB'!A:A,MATCH(LEFT(A2,FIND(" ",A2)-1),'SheetB'!A:A,0))

adjust sheetnames and references to suit.

You will get #N/A if first word not found in any first word of SheetB cells.

If you have XL2007 or later, you can use IFERROR() to return blanks instead of errors

=IFERROR(INDEX('SheetB'!A:A,MATCH(LEFT(A2,FIND(" ",A2)-1),'SheetB'!A:A,0)),"")... else...

=IF(ISNUMBER(MATCH(LEFT(A2,FIND(" ",A2)-1),'SheetB'!A:A,0)),
INDEX('SheetB'!A:A,MATCH(LEFT(A2,FIND(" ",A2)-1),'SheetB'!A:A,0)),"")