partial text vlookup or lookup

[Richiban11]

Hey all,

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

I would like for any blank cell that is in column B to auto populat
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

COLUMN
BILLY BOB THORTON
JENNIFER A


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

Please help!

Thank you,
Richiban1

 

[isabelle]

hi Richiban11,

array formula to validate with ctrl + shift + enter

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

--
isabelle



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