Can anyone help

  • Thread starter Thread starter ricker
  • Start date Start date
R

ricker

Wondering if someone can figure this out as to how to write it?

B C D E F G H I
J
1 Type L R W H D Face Full or shortCP
2 lower ce ce 10 35 1/4 24 Prdrs/dwrs f
3 upper ce ce 10 30 24 prdrs s
4 ts ce ce 10 84 24 prdrs y

It would have to know that lower, upper,or ts are entered in C2
(OR(W.O.!C3="lower",W.O.!C3="ts"),IF(W.O.!C3="upper","")

then it would have to know i2 to be either prdrs/dwrs, or prdrs, o
dr/dwr, or 2dwr,or 3dwr , or 4dwr, or 5dwr.

Then it would need to know if j2 was ” f” for full, or “s” for short

So if C2 was lower or ts and i2 was prdrs/dwrs, and J2 was “f”
whatever dimension is in G2 would be put on another sheet referencin
this G2-5.5

Also so C2 was upper and i2 was prdrs or open, and J2 was “s”, whateve
dimension is in G2 would be put on another sheet referencing thi
G2-1.5

Ric
 
=IF(AND(OR(W.O.!C3="lower",W.O.!C3="ts",W.O.!C3="upper"),OR(W.O.!I3="prdrs/d
wrs",
W.O.!I3="prdrs",W.O.!I3="dr/dwr",W.O.!I3="2dwr",W.O.!I3="3dwr",W.O.!I3="4dwr
",W.O.!I3="5dwr"),OR(W.O.!J3="f",W.O.!J3="s")),match_action,no_match_action)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top