Formula help
Closed
BeatsA
russp5
- Posts
- 1
- Registration date
- Friday August 2, 2013
- Status
- Member
- Last seen
- August 2, 2013
russp5
- Posts
- 4
- Registration date
- Friday August 2, 2013
- Status
- Member
- Last seen
- August 2, 2013
Related:
- Formula help
- Excel @ in formula ✓ - Forum - Excel
- 1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
- Little alchemy formulas - Guide
- Logitech formula vibration feedback wheel driver windows 10 - Download
- Ms excel marksheet grade formula - Guide
1 reply
russp5
Aug 2, 2013 at 01:24 PM
- Posts
- 4
- Registration date
- Friday August 2, 2013
- Status
- Member
- Last seen
- August 2, 2013
Aug 2, 2013 at 01:24 PM
I would first start with a MATCH formula for the column (width) and row (drop). This will get the coordinates for the price table by referencing the first row and column with values.
Next you can use the value in an OFFSET function to return the price based on the coordinates.
Next you can use the value in an OFFSET function to return the price based on the coordinates.