Can we use hlookup & vlookup in a single formula ?
If i have the data on the Product monthly wise sales in the form of an array.
jan / feb / mar / apr / may..........
Prod a
Prod b
Prod c
Prod e
.......and so on.
How do i retrieve the value of Product c in the month of Apr ?
This would mean we would require to use hlookup as well as vlookup formulae.

Pls. help.

br, Sk.