HELP..Doing Benefit work and have a quick question

[Stephanie]

I am working with two worksheets. I would like to pull
information from one sheet to the other.

Example: Worksheet 1 is a list of guests coming to our
benefit. The data is name, address, paddle all in
separate columns. Worksheet 2 is going to be the auction
items. The data is art work, artist, paddle, bid.

What I would like to do is type the paddle number on
Worksheet 2 and have it pull all the details from
Worksheet 1.

I think linking will do this but I'm not sure.

Any advice? Thanks in advance.

 

[CLR]

Sounds like a job for the VLOOKUP function to me........create a
NamedRange of all your data on Sheet 1, making sure to use the Paddle number
in the leftmost column and the other data on an individual guest straight
across the same row.......then use several VLOOKUPS in your sheet 2 to key
on whatever column you type the paddle number into on sheet 2......

hth
Vaya con Dios,
Chuck, CABGx3