Hi all!
Working on a sheet that will do automatic upgrades of hotel rooms .
SO my chart looks like this:
A B C D E
1Original room Category Desired room Categorie Price
2112 E 345 A ?
So I have made a chart (on a different worksheet) with all the categories and their prices that looks like this:
A B C D E F G .....
Cat E D C B A
1 E 0 90 100 134 200
2 D 90 0 10 44 110
3 C 100 0 0 .......
And so on.
So I need to find a formula that will look for the original category to the one I want to upgrade to and tell me the price.
Any suggestions? Can somebody help? Thanks!![]()
Bookmarks