Formula help
Closed
BeatsA
Posts
1
Registration date
Friday August 2, 2013
Status
Member
Last seen
August 2, 2013
-
Aug 2, 2013 at 10:22 AM
russp5 Posts 4 Registration date Friday August 2, 2013 Status Member Last seen August 2, 2013 - Aug 2, 2013 at 01:24 PM
russp5 Posts 4 Registration date Friday August 2, 2013 Status Member Last seen August 2, 2013 - Aug 2, 2013 at 01:24 PM
Related:
- Formula help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
russp5
Posts
4
Registration date
Friday August 2, 2013
Status
Member
Last seen
August 2, 2013
1
Aug 2, 2013 at 01:24 PM
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.