iWork
Q: Need a formula that uses vlookup & hlookup to return a single value
I am creating a pricing worksheet with multiple values. In the table below if I select size 16 in Blue the result should return 19.5
| Red | Yellow | Blue | Green | |
| size | ||||
| 10 | 5 | 6.25 | 7.5 | 8.75 |
| 12 | 13 | 14.25 | 15.5 | 16.75 |
| 14 | 15 | 16.25 | 17.5 | 18.75 |
| 16 | 17 | 18.25 | 19.5 | 20.75 |
| 20 | 19 | 20.25 | 21.5 | 22.75 |
iPad Air, iOS 9.3.5
Posted on Sep 24, 2016 6:04 AM
by Barry,Solvedanswer
iWork
Hi Eric,
Larger table is Table 1.
Formula is in C2 of Table 2.
C2: =INDEX(Table 1::A1:E7,MATCH(A,Table 1::A,0),MATCH(B2,Table 1::1:1,0),area-index)
Regards,
Barry
Posted on Sep 27, 2016 4:26 PM
