tcarwardine
New Member
- Joined
- Jul 13, 2016
- Messages
- 26
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
I think this may be an Index/Match formula but not 100%
Trying to work out a cost based on two factors as displayed below.
<tbody>
</tbody>
Then I have a table to with drop downs to select which Hardware Category and which City for delivery:
<tbody>
</tbody>
I am having trouble populating the Cost cell (C2)
Thanks in advance
I think this may be an Index/Match formula but not 100%
Trying to work out a cost based on two factors as displayed below.
Hardware Category | Berlin | Amsterdam | London | Frankfurt | Copenhagen | Lisbon | Madrid | Barcelona |
1 | £175 | £175 | £35 | £175 | £135 | £235 | £235 | £235 |
2 | £185 | £185 | £35 | £15 | £255 | £255 | £255 | £255 |
<tbody>
</tbody>
Then I have a table to with drop downs to select which Hardware Category and which City for delivery:
Destination | Hardware Category | Cost |
<tbody>
</tbody>
I am having trouble populating the Cost cell (C2)
Thanks in advance