Is this a lookup function of sorts? Where do I start?

[AFST]

I'm sure there's a very easy answer to this, I've just never had to do it before and don't really know where to start. I have a cell with a drop down list of names in it (call it the name cell). What I would like is a formula that evaluates a column for a matching name based on whats in the "name cell" and it returns all the info in the same row as the met criteria. for example:

A B C
1 Gary Red Large
2 Scott Blue Medium
3 Bill Green Small

So if I had selected Scott in the "name cell" I'm looking for it to return:

Scott Blue Medium

Thanks for any help on this one guys

 

[jeffreybrown]

Yes I cannot see your screen shot either.

Look at my signature block and you'll see an HTML maker which you can use to post a shot of your data which is much more preferred since we can copy and paste the data for testing purposes.

A picture is often not much use.

If you can't make a representative sample to post, than PM me your e-mail and you can send me the worksheet.