Task 1 of 1
In I2:I4, find the shipping cost for the city and weight in the table on the left.
Lesson theory
INDEX has a third argument, the column number. Find both numbers with MATCH and you get the value at the intersection:
=INDEX($B$2:$E$5,MATCH(G2,$A$2:$A$5,0),MATCH(H2,$B$1:$E$1,0))This is how shipping rates, size-based price lists and timetables work.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page