Hi David,

See Debra Dalgleish's VLooup tutorial at:


Excel -- Worksheet Functions -- VLookup
http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



" wrote
in message ...
Hi,
I'm looking to create a vlookup that will extract data from within a cell
that matches with something found in a range.

input cell range results cell
car cat dog farm car car