Take a look at HLOOKUP function in help

"justinhill18" wrote in message
...
I have a probably very simple question. I have two worksheets and need to
take a list of data from one and list it in the other one. I specifically
want to type the title of any of the columns and have the rest of the data
for that column auto fill where I need it to.

Ex:
Worksheet 1
Model A B C D
Price 1 2 3 4
Upgrade W X Y Z

Worksheet 2 (want data from "worksheet 1, column A" to automatically fill
in
when I type in the model "A, B, C, Etc.)
Model A
Price
Upgrade


I appreciate any help on this. I have tried looking up all over the
internet
but I guess I can't figure out how to ask what I am trying to do.
Thanks!!!

Justin