David,

Thanks for your suggestion. I have been trying to use it but I keep gettting
the error#N/A. I am not sure if I am using it wrong or if there is a problem
with my list. I have a large file about three hundred lines long and have
used the create list function in excel to make it a drop down list. I wrote
your formula in a different cell on the same worksheet and on differnt ones
trying to get the necessary info but it does not work.

Can you give me some more helpful hints.

Thanks
Andrew

"David Billigmeier" wrote:

Assume your 'first column' is A and the other six are B,C,D,E,F and G. To
lookup a value in A and return the corresponding value in B use:

=VLOOKUP("<lookup value",A:G,2,0)

likewise to lookup the value in column C use:

=VLOOKUP("<lookup value",A:G,3,0)

Notice the only thing changing is the 3rd parameter, which is the number of
columns out from column A that you want to reference.
--
Regards,

David Billigmeier



"jandrewscott" wrote:

I have a large list of dimensions that in the first column has a name and the
other six columns has dimensions. I want to be able to search for a certain
name and use the data in that row in other cells for calculations.