strongman86
Board Regular
- Joined
- Feb 15, 2017
- Messages
- 115
- Office Version
- 2019
- Platform
- Windows
Guys,
Need formula to put in column F to lookup at column A & B and find matching colour and return adjacent weight value. Thanks.
<tbody>
</tbody>
Need formula to put in column F to lookup at column A & B and find matching colour and return adjacent weight value. Thanks.
| A | B | C | D | E | F | |
| 1 | Colour | Weight | Colour | Weight | ||
| 2 | Red | 1.44 | Red | |||
| 3 | Blue | 1.55 | Red | |||
| 4 | Green | 2.00 | Blue | |||
| 5 | Green | |||||
| 6 | Blue |
<tbody>
</tbody>
