Using certain data from lists in other cells in Excel.
 

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.

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.

David,

I have been trying to use the formula you told me about with no success. I
continue to get #N/A errors when I use this.

I have about 275 lines of information. In the first column is a name and the
other five colums are decimal numbers. I have used under the "data" menu the
"create list" function for the data and that is working fine. When I enter
the formula into another cell on the same or other workbooks I get the same
error.

Any more helpful hints would be greatly appreciated.

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.

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.