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

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

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