Search a Table, find, and copy all data from the row

[Toddman]

Would someone be kind enough to help me on this? I want to take a list
compare it to a table, and if a match copy all of the elements from th
table in the same row in which the element match was found:



LIST

CAT
DOG
MOUSE

TABLE

HORSE BROWN LARGE Worker
DOG WHITE SMALL Pet

When list matches table, I want to copy the information from th
following columns (e.g. WHITE, SMALL, Pet) and place in columns next t
the item in the list, so the list would then look like:

CAT
DOG WHITE SMALL Pet
MOUSE

Thank you for any help

 

[Frank Kabel]

Hi
use VLOOKUP for this. e.g
=VLOOOKUP(A1,'table'!$A$1:$D$20,2,0)