excel formula question

**surin526** · 03-06-2015, 07:56 PM

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!

**Pete_UK** · 03-06-2015, 08:25 PM

It would help if you attached a sample workbook - the FAQ describes how to.

Pete

**FDibbins** · 03-06-2015, 09:12 PM

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.