Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jandrewscott
 
Posts: n/a
Default 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   Report Post  
David Billigmeier
 
Posts: n/a
Default

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   Report Post  
jandrewscott
 
Posts: n/a
Default

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   Report Post  
jandrewscott
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to alter data on HTML webpage into Excell cells as numbers? roameri New Users to Excel 6 July 31st 05 11:42 PM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Count cells with data shoiley New Users to Excel 5 November 28th 04 08:23 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"