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