partial text vlookup or lookup
 

Hey all,

I was wondering if you could help me out with a little problem i'm having with vlookup.

I would like for any blank cell that is in column B to auto populate information from a seperate table which relates to column A.

Example:

Column A
BILLYBOB0902
JEN0506

COLUMN B (all cells are blank)



Seperate table:

COLUMN C
BILLYBOB1003
JEN0607

COLUMN D
BILLY BOB THORTON
JENNIFER A


i.e-When ever column A has BILLYBOB in it, I want column B to autopopulate with "BILLY BOB THORTON"

Please help!

Thank you,
Richiban11

partial text vlookup or lookup
 

hi Richiban11,

array formula to validate with ctrl + shift + enter

=INDEX(D$1:D$10,MATCH("*"&LEFT(A1,8)&"*",OFFSET(C$ 1:C$10,0,0),0))

--
isabelle



Le 2012-06-14 17:19, Richiban11 a écrit :
Hey all,

I was wondering if you could help me out with a little problem i'm
having with vlookup.

I would like for any blank cell that is in column B to auto populate
information from a seperate table which relates to column A.

Example:

COLUMN A [/b]
BILLYBOB0902
JEN0506

*COLUMN B* (ALL CELLS ARE BLANK)



SEPERATE TABLE:

*COLUMN C*
BILLYBOB1003
JEN0607

[b]COLUMN D
BILLY BOB THORTON
JENNIFER A


i.e-When ever column A has BILLYBOB in it, I want column B to
autopopulate with "BILLY BOB THORTON"

Please help!

Thank you,
Richiban11