Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Count cells with data | New Users to Excel |