Dear Friends,
Please help the formula to find the data Value of Zone 2 with 3.0kg, I have try to use the lookup with build up number “Kg”, and also build up “Zone” but still can not get it.
Please kindly help me.
Thank you
Weight (kg) | 0.5 | 1.0 | 1.5 | 2.0 | 2.5 | 3.0 | 3.5 | 4.0 | 4.5 | 5.0 | 5.5 | 6.0 | 6.5 | 7.0 | 7.5 | 8.0 | 8.5 | 9.0 | 9.5 | 10.0 | 10.5 | 11.0 | 11.5 | 12.0 | 12.5 | 13.0 | 13.5 | 14.0 | 14.5 | 15.0 | 15.5 | 16.0 | 16.5 | 17.0 | 17.5 | 18.0 | 18.5 | 19.0 | 19.5 | 20.0 | 21.0 | 22.0 | 23.0 | 24.0 | 25.0 | 26.0 | 27.0 | 28.0 | 29.0 | 30.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Zone 1 | 205,050 | 244,583 | 275,296 | 306,009 | 336,722 | 363,646 | 390,570 | 417,494 | 444,418 | 471,342 | 496,183 | 521,024 | 545,865 | 570,706 | 595,547 | 620,388 | 645,229 | 670,070 | 694,911 | 719,752 | 742,912 | 766,072 | 789,232 | 812,392 | 835,552 | 858,712 | 881,872 | 905,032 | 928,192 | 951,352 | 973,976 | 996,600 | 1,019,224 | 1,041,848 | 1,064,472 | 1,087,096 | 1,109,720 | 1,132,344 | 1,154,968 | 1,177,592 | 1,222,305 | 1,267,018 | 1,311,731 | 1,356,444 | 1,401,157 | 1,445,870 | 1,490,583 | 1,535,296 | 1,580,009 | 1,624,722 |
Zone 2 | 209,460 | 266,475 | 314,670 | 362,865 | 411,060 | 449,438 | 487,816 | 526,194 | 564,572 | 602,950 | 641,328 | 679,706 | 718,084 | 756,462 | 794,840 | 833,218 | 871,596 | 909,974 | 948,352 | 986,730 | 1,020,539 | 1,054,348 | 1,088,157 | 1,121,966 | 1,155,775 | 1,189,584 | 1,223,393 | 1,257,202 | 1,291,011 | 1,324,820 | 1,358,629 | 1,392,438 | 1,426,247 | 1,460,056 | 1,493,865 | 1,527,674 | 1,561,483 | 1,595,292 | 1,629,101 | 1,662,910 | 1,729,722 | 1,796,534 | 1,863,346 | 1,930,158 | 1,996,970 | 2,063,782 | 2,130,594 | 2,197,406 | 2,264,218 | 2,331,030 |
If this is your table structure, you can read it like LOOKUP(“Zone 2”,“TableName”,“Weigth”,“3.0”)
For reference:
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |