Formula help
Closed
BeatsA
Posts
1
Registration date
Friday 2 August 2013
Status
Member
Last seen
2 August 2013
-
2 Aug 2013 à 10:22
russp5 Posts 4 Registration date Friday 2 August 2013 Status Member Last seen 2 August 2013 - 2 Aug 2013 à 13:24
russp5 Posts 4 Registration date Friday 2 August 2013 Status Member Last seen 2 August 2013 - 2 Aug 2013 à 13:24
Related:
- Formula help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Spreadsheet formula - Guide
- Formula to calculate vat in excel - Guide
- Grade formula in excel marksheet - Guide
1 response
russp5
Posts
4
Registration date
Friday 2 August 2013
Status
Member
Last seen
2 August 2013
1
2 Aug 2013 à 13:24
2 Aug 2013 à 13:24
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.