You're welcome. Thanks for the feedback!

Biff

"Sheaky" <Sheaky@discussions.microsoft.com> wrote in message
news:1A46462F-DFBA-452E-9B28-8EFC1E50EBC6@microsoft.com...
> Biff,
> Thanks for your help. I am a new user and am still unfamiliar with all
> excel can do. Your right, in the limited sample, it does seem redundant.
> However, there is a third and fourth worksheet. Sheet 1 is going to be
> strictly the window measurements and in which direction the fasteners will
> run for certain shutter applications. Sheet 2, 3 and 4 will be different
> types of shutters. Sheet 2 and 3 will require the span information
> because
> it might change, but the 4th sheet information won't require the span
> because
> it will always be horizontal (accordion shutters).
> Your help seems to be the answer though. I appreciate it VERY much. I'm
> getting tired of reentering the same information manually (literally, ink
> and
> paper), and I hope with the help of ppl like you, ill figure this out.
> Thanks, Thanks and Thanks again
>
> "Biff" wrote:
>
>> Hi!
>>
>> You can use a lookup formula to lookup the window number and return the
>> span: (V or H)
>>
>> Based on your limited sample, enter this formula in Sheet2 D2:
>>
>> =VLOOKUP(A2,Sheet1!A$2:D$3,4,0)
>>
>> Then you'd just drag copy down as needed.
>>
>> This seems kind of redundant to me since you already have all the info
>> you
>> seem to need on Sheet1.
>>
>> Biff
>>
>> "Sheaky" <Sheaky@discussions.microsoft.com> wrote in message
>> news:96DEDAEC-00A3-4A54-87E8-762B731A51DA@microsoft.com...
>> > sample of 2 worksheets for measuring hurricane shutter
>> > Sheet 1
>> > a b c d
>> > 1 window width heigth span
>> > 2 1 36 48 vertical
>> > 3 2 36 48 horizontal
>> > Sheet 2
>> > a b c
>> > 1 window span non span
>> > 2 1 36 48
>> > 3 2 48 36
>> >
>> > the only difference in the two examples is that the run of the
>> > fasteners
>> > is
>> > in a vert. or horiz. position. is there an argument that will make
>> > excel
>> > recognize that the width might be either the span or non-span of the
>> > window
>> > depending on which direction sheet 1 column d stipulates? For example,
>> > can
>> > I
>> > get it to state that the span of the shutter is the height if the
>> > fasteners
>> > run vertically, or the span is the width if they run horizontally?
>> > This
>> > is
>> > probably simple for ya'll, or I might not be providing enough info.
>> > Any
>> > help
>> > would be greatly appreciated, if this works, ill be switching my entire
>> > estimating forms to EXCEL from ink and paper. Thanks
>> >
>> >
>> >
>> >
>>
>>
>>