Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 198
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi, Does anyone know a formula that match Client ID & weight and return correct Weight Range?
[TABLE="width: 497"]
<tbody>[TR]
[TD]Client ID[/TD]
[TD]Weight[/TD]
[TD]Weight Range[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Home[/TD]
[TD]21.05[/TD]
[TD] ??[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Local[/TD]
[TD]28.50[/TD]
[TD] ??[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight Range Lower[/TD]
[TD]Weight Range Upper[/TD]
[TD]Client ID[/TD]
[TD]Weight Range[/TD]
[/TR]
[TR]
[TD]1.0000[/TD]
[TD]26.9900[/TD]
[TD]Local[/TD]
[TD]Up to 27kg[/TD]
[/TR]
[TR]
[TD]22.9901[/TD]
[TD]42.9900[/TD]
[TD]Local[/TD]
[TD]27kg up[/TD]
[/TR]
[TR]
[TD]17.9901[/TD]
[TD]22.9900[/TD]
[TD]Home[/TD]
[TD]18kg - 23kg[/TD]
[/TR]
[TR]
[TD]22.9901[/TD]
[TD]26.9900[/TD]
[TD]Home[/TD]
[TD]23kg-27kg[/TD]
[/TR]
[TR]
[TD]26.9901[/TD]
[TD]30.9900[/TD]
[TD]Home[/TD]
[TD]27kg-31kg[/TD]
[/TR]
[TR]
[TD]30.9901[/TD]
[TD]42.9900[/TD]
[TD]Home[/TD]
[TD]31kg up[/TD]
[/TR]
[TR]
[TD]42.9901[/TD]
[TD]150.0000[/TD]
[TD]Home[/TD]
[TD]42kg up[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 497"]
<tbody>[TR]
[TD]Client ID[/TD]
[TD]Weight[/TD]
[TD]Weight Range[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Home[/TD]
[TD]21.05[/TD]
[TD] ??[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Local[/TD]
[TD]28.50[/TD]
[TD] ??[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight Range Lower[/TD]
[TD]Weight Range Upper[/TD]
[TD]Client ID[/TD]
[TD]Weight Range[/TD]
[/TR]
[TR]
[TD]1.0000[/TD]
[TD]26.9900[/TD]
[TD]Local[/TD]
[TD]Up to 27kg[/TD]
[/TR]
[TR]
[TD]22.9901[/TD]
[TD]42.9900[/TD]
[TD]Local[/TD]
[TD]27kg up[/TD]
[/TR]
[TR]
[TD]17.9901[/TD]
[TD]22.9900[/TD]
[TD]Home[/TD]
[TD]18kg - 23kg[/TD]
[/TR]
[TR]
[TD]22.9901[/TD]
[TD]26.9900[/TD]
[TD]Home[/TD]
[TD]23kg-27kg[/TD]
[/TR]
[TR]
[TD]26.9901[/TD]
[TD]30.9900[/TD]
[TD]Home[/TD]
[TD]27kg-31kg[/TD]
[/TR]
[TR]
[TD]30.9901[/TD]
[TD]42.9900[/TD]
[TD]Home[/TD]
[TD]31kg up[/TD]
[/TR]
[TR]
[TD]42.9901[/TD]
[TD]150.0000[/TD]
[TD]Home[/TD]
[TD]42kg up[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]