Am trying to lookup a value that matches multiple rows and column criteria. Eg:
January February March April
Leather Black Big Bag 100 200 300 400
Leather Red Small Bag 200 300 400 500
Leather Green Big Bag 300 400 500 600
Leather Yellow Small Bag 400 500 600 700
Cotton Black Big Bag 500 600 700 800
Cotton Red Small Bag 600 700 800 900
Cotton Green Big Bag 700 800 900 1000
Cotton Yellow Small Bag 800 900 1000 1100
Lookup value for the following combination:
Cotton Green Big Bag January
Cotton Red Small Bag March
Leather Yellow Small Bag February
Could you please help write a formula that would lookup the value for the above combination.
Thanks much in advance
Bookmarks