Selecting data

Hi

How do I set up a formula that will pick out a particular number in a row ?
I have 12 monthly columns of data ( 1 to 12 ) , showing sales/profit performance
I need to put in a formula or key that will pick out a month , and change it as needed ( eg show month 1 first , then say month 4 , depends on user)

At the moment the data is just in excel and not in a data table or anything, do I need to use one of these

Thanks

Hi,

Can you post the excel file that you have?

Hi

This is the full file

Hi,

See the attached file.

I have used the following formula to fetch the YTD numbers based on a variable.

=SUM(INDEX(Sheet1!$D$8:$O$20,MATCH($A7,Sheet1!$A$8:$A$20,0),1):INDEX(Sheet1!$D$8:$O$20,MATCH($A7,Sheet1!$A$8:$A$20,0),$B$3))

Hi

Thats great thanks solves it

I wonder should I set up a data table for the information on Sheet 1 - I have calculated the Margin figure from the Sales and cost of sales figures ? or is it okay as is . having trouble getting my head around when to use them.