Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filling out list based on other lists
I have a workbook with 3 sheets. Sheet 1 is the design and dimensions where
the information is gathered. Sheet 2 is a complete material list with blank quantities. Sheet 3 is lists based lengths and widths that will be gathered on Sheet 1. Here is an example of one of the lists on Sheet 3. Length Quantity 11 24 12 27 13 29 14 31 15 33 16 35 17 38 18 40 19 42 20 44 So on Sheet 1 the Length is entered into a text box. What I need to be able to do is take the Length, say 16, entered into that text box on sheet 1, have it reference this list on sheet 3 and correspond 16 to 35, and then take the 35 and enter it into a certain spot on sheet 2. Any help would be appreciated. Chris -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200510/1 |
#2
|
|||
|
|||
Hi Chris,
In the cell you want the result on sheet 1, 35 in this case, enter: =VLOOKUP(F1,Sheet2!A2:B11,2,0) Where F1 is the cell that holds the inputted value 16, And the lengths are in column A of sheet 2 And the quantitys are in column B of sheet 2. HTH Regards, Howard "Chris W via OfficeKB.com" <u12698@uwe wrote in message news:55b03383809ae@uwe... I have a workbook with 3 sheets. Sheet 1 is the design and dimensions where the information is gathered. Sheet 2 is a complete material list with blank quantities. Sheet 3 is lists based lengths and widths that will be gathered on Sheet 1. Here is an example of one of the lists on Sheet 3. Length Quantity 11 24 12 27 13 29 14 31 15 33 16 35 17 38 18 40 19 42 20 44 So on Sheet 1 the Length is entered into a text box. What I need to be able to do is take the Length, say 16, entered into that text box on sheet 1, have it reference this list on sheet 3 and correspond 16 to 35, and then take the 35 and enter it into a certain spot on sheet 2. Any help would be appreciated. Chris -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200510/1 |
#3
|
|||
|
|||
Thanks, exactly what I needed to get me going!
L. Howard Kittle wrote: Hi Chris, In the cell you want the result on sheet 1, 35 in this case, enter: =VLOOKUP(F1,Sheet2!A2:B11,2,0) Where F1 is the cell that holds the inputted value 16, And the lengths are in column A of sheet 2 And the quantitys are in column B of sheet 2. HTH Regards, Howard I have a workbook with 3 sheets. Sheet 1 is the design and dimensions where the information is gathered. Sheet 2 is a complete material list with [quoted text clipped - 27 lines] Chris -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200510/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
Data Validation lists - entering value not in list | Excel Discussion (Misc queries) | |||
Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
Data Lists | Excel Worksheet Functions |