Look up formula for 2 value in 1 column

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”)

2 Likes

For reference:

1 Like