hi,

i have a tab called "baselines" that has data for quarter 1 from C2, C3, C4 to C8 , data for quarter 2 is from C10, C11, C12 to C16, data for quarter 3 is from C18, C19, C20 to C24, data for quarter 4 is from C26,C27,C28 to C32

in another tab called APAC, i will be having a column for quarter which would say 1,2,3 or 4 based on the quarter. Want to be able to refer to this quarter table in "APAC" page and call out the corresponding values from "baselines" tab

say for quarter 2, formula should be able to get C10,C11 to C16 values..

please help!

thanks!