Spreadsheet: 677543d1589391350-compute-text-that-is-in-another-column-based-on-a-match-example
Sheet: Example

 | Solid Board | 1.5 |  |  | found in B | Found in B
 | [NAME] | 0.7 |  | F | 0.7 | 0.8 |  |  |  | Thickness | 0.35
 | [NAME] | 0.8 |  | thickness | [NAME] | [NAME]
 |  |  |  | 0.35
 |  |  |  | 0.4 |  |  |  |  |  | Product Code | SRB1-ABSNL
 |  |  |  | 0.45
 |  |  |  | 0.5
 |  |  |  | 0.55
 |  |  |  | 0.6
 |  |  |  | 0.65
 |  |  |  | 0.7
 |  |  |  | 0.75
 |  |  |  | 0.8
 |  |  |  | 0.85
 |  |  |  | 0.9
 |  |  |  | 0.95
 |  |  |  | 1
lower range | upper range | Channel | A | B | C | D | E | Tape Specifiction | Product Code
 |  |  |  | [NAME]
1.2 | 1.6 | 1.2 - 1.6 | 1.9 - 2.3 | 0.7 | 0.5 | 0.3 | 12 | Normal | SRB1-ABSNL
1.2 | 1.6 | 1.2 - 1.6 | 1.9 - 2.3 | 0.7 | 0.5 | 0.3 | 12 | Strong | SBSR1-ABSNL
1.3 | 1.3 | 1.3 | 2 | 0.7 | 0.7 | 0.6 | 8 | Normal | SRBZ
1.7 | 2.3 | 1.7 - 2.3 | 2.4 - 3.0 | 0.7 | 0.5 | 0.3 | 12 | Normal | SRB1ML2
1.8 | 2.3 | 1.8 - 2.3 | 2.5 - 3.0 | 0.7 | 0.7 | 0.4 | 12 | Normal | XR-270-007
1.7 | 2.3 | 1.7 - 2.3 | 2.4 - 3.0 | 0.8 | 0.3 | 0.3 | 12 | Normal | SRBMLZ
1.8 | 2.3 | 1.8 - 2.3 | 2.5 - 3.0 | 0.8 | 0.8 | 0.4 | 12 | Normal | XR-270-008
2.7 | 2.7 | 2.7 | 2.7 | 1 | 1.2 | 0.3 | 7 | Normal | SRBA/BABS
2.5 | 3 | 2.5 - 3.0 | 2.5 - 3.0 | 1 | 1 | 0.4 | 12 | Normal | XR-270-010
2.5 | 3 | 2.5 - 3.0 | 2.5 - 3.0 | 1 | 0.7 | 0.3 | 12 | Normal | SRB2-ABSNL
2.5 | 3 | 2.5 - 3.0 | 2.5 - 3.0 | 1 | 0.7 | 0.3 | 12 | Strong | SBSRB2-ABSNL
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 1.1 | 1 | 0.7 | 12 | Normal | SRB7
2.5 | 3 | 2.5 - 3.0 | 2.5 - 3.0 | 1.2 | 0.8 | 0.3 | 12 | Normal | XR-270-012
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 1.5 | 0.9 | 0.3 | 12 | Normal | SRB3-ABSNL
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 1.5 | 0.9 | 0.3 | 12 | Strong | SBSRB3-ABSNL
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 1.5 | 1.4 | 0.2 | 12 | Normal | SRBC
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 1.5 | 1.4 | 0.2 | 12 | Strong | SBSRBC
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 1.5 | 1.5 | 0.3 | 12 | Normal | SRBF
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 1.5 | 1.5 | 0.3 | 12 | Strong | SBSRBF
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 1.5 | 1.5 | 0.7 | 12 | Normal | SRBG
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 1.5 | 1.5 | 0.7 | 12 | Strong | SBSRBG
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 1.5 | 1.5 | 0.3 | 12 | Normal | [NAME]
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 1.5 | 1.5 | 0.3 | 12 | Strong | SBSRBN
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 2 | 1 | 0.4 | 12 | Normal | SRBD
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 2 | 1.2 | 0.3 | 12 | Normal | SRBK
3.8 | 4.3 | 3.8 - 4.3 | 3.8 - 4.3 | 2 | 1.2 | 0.3 | 12 | Strong | SBSRBK
4.2 | 4.8 | 4.2 - 4.8 | 4.2 - 4.8 | 2 | 1.1 | 0.3 | 12 | Normal | SRB4-ABSNL
4.2 | 4.8 | 4.2 - 4.8 | 4.2 - 4.8 | 2 | 1.1 | 0.3 | 12 | Strong | SBSRB4-ABSNL
4.7 | 5.3 | 4.7 - 5.3 | 4.7 - 5.3 | 2 | 2 | 0.3 | 12 | Normal | SRBH
4.7 | 5.3 | 4.7 - 5.3 | 4.7 - 5.3 | 2 | 2 | 0.3 | 12 | Strong | SBSRBH
4.7 | 5.3 | 4.7 - 5.3 | 4.7 - 5.3 | 2 | 1 | 0.4 | 12 | Normal | SBRJ
4.7 | 5.3 | 4.7 - 5.3 | 4.7 - 5.3 | 2 | 1.3 | 0.7 | 12 | Normal | SRBL
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 2 | 2 | 0.7 | 12 | Normal | SRBM
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 2 | 1.3 | 0.3 | 12 | Normal | SRB5-ABSNL
4.9 | 5.3 | 4.9 - 5.3 | 4.9 - 5.3 | 2 | 1.3 | 0.3 | 12 | Strong | SBSRB5-ABSNL
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 2 | 2 | 0.3 | 12 | Normal | SRBP
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 2 | 2 | 0.3 | 12 | Strong | SBSRBP
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 2.5 | 2.5 | 0.3 | 12 | Normal | [NAME]
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 2.5 | 2.5 | 0.3 | 12 | Strong | SBSRBQ
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 3 | 1.6 | 0.7 | 12 | Normal | SRBR
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 3 | 3 | 0.3 | 12 | Normal | SRBS
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 3 | 3 | 0.7 | 12 | Normal | SRBT
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 3 | 1.8 | 0.3 | 12 | Normal | SRB6-ABSNL
5.7 | 6.3 | 5.7 - 6.3 | 5.7 - 6.3 | 3 | 1.8 | 0.3 | 12 | Strong | SBSRB6-ABSNL