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" wrote in message
...
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