HI, how to insert a predetermine value on B2 and D2 from a specific value on A2. A2 has a pop up menu 0-13.
I Have a formula but it only works with 1 value, IF(LEN(A2)>1,,LOOKUP(A2,'Table 1-1'::A2,'Table 1-1'::B2))
any ideas? Im using numbers on ipad Air 2
| GTOW | CG %MAC | GTOW | CG %MAC | |
| | 44086 | | |
TAble 1:
| Pax | CG %MAC | CG %MAC | |
| 0 | 36.5 - 44.5 | 38.3 | |
| 1 | 36.5 - 44.5 | 37.74 | |
| 2 | 36.5 - 44.2 | 37.19 | |
| 3 | 36.5 - 44.0 | 36.78 | |
| 4 | 36.4 - 43.7 | 36.40 | |
| 5 | 36.4 - 43.5 | 36.11 | |
| 6 | 36.3 -43.2 | 35.83 | |
| 7 | 36.2 -42.9 | 35.72 | |
| 8 | 36.1 - 42.7 | 35.62 | |
| 9 | 36.0 - 42.3 | 35.64 | |
| 10 | 36.0 - 42.1 | 35.67 | |
| 11 | 36.0 - 41.9 | 35.76 | |
| 12 | 36.0 - 41.6 | 35.92 | |
| 13 | 36.0 - 41.4 | 36.08 | |
