santoshloka
Board Regular
- Joined
- Aug 31, 2017
- Messages
- 125
Beam | S1 | S1a | S2 | S2a | S3 | S3a |
Pier Nos | P1 | P2 | P3 | P4 | P5 | P6 |
Input-1 | Input-2 | |||||
P1-P2 | S1 |
Looking for conditional formula
I will change values manually in Input-1 and input-2,if P1-P2 =S1 OR P2-P3=S3a OR P3-P4=S3...etc
Based on below cell values in Input-1,Input-2
find the "Pier Nos" and match the color in "Beam"