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.