=VLOOKUP("Look-up Value",Range or an array,Column Index No,range lookup)
Example: (range say d12 to g15)
apr may Jun
store-1 100 250 400
store-2 150 350 600
store-3 500 800 300
Following formula will return a value of 600 (that is the value for store-2
in column 4.
=VLOOKUP("Store-2",D12:G15,4,0)
HOpe this helps.