Index match formula??

[vicbri]

Hi, I am hoping someone can help me understand what I am doing wrong and help point me in the right direction...
I have a very large spreadsheet with a number of sheets. One of these sheets is to draw information from another one and I am having some difficulty getting the information I am wanting. After researching the formulas that are possible I believe the index/match formula would be the one to use, however, I am either not understanding it properly or entering it all wrong.
This is what I am trying to acheive:
Sheet A: Monthly sales/purchase data (always changing as new months are added to the sheet)
Sheet B: Yearly figures
Sheet A works horizontally with new months pushing the old to the right as they are added and includes totals for each month of "net sales", "gross sales", "GST", "purchases" etc.
So... for example, how can I return the value of "Sales" (4500) for the month of April 22 to SHEET B? I am wanting Sheet B to automatically populate with the information rather than me having to manually enter every figure in each month. I have attached an example of what I am trying to do and tried using the index/match formula as follows:
=INDEX(SheetA!2:5,MATCH(SheetB!A3,SheetA!1:1)+3,2)
(I did try to upload a minisheet- but was unable to so I do hope the images are okay).
Thanks in advance for anyone who can help with this.

 

[Alex Blakenburg]

Try this:

=INDEX(SheetA!2:5,1,MATCH(A3,SheetA!1:1)+1)

 

[vicbri]

Try this:

=INDEX(SheetA!2:5,1,MATCH(A3,SheetA!1:1)+1)

Thank you SO much! It works!! I was just becoming resigned to the thought that I would be entering them in every month!! Huge time savings and the formula makes a lot more sense to me now too!! Thanks so much Alex, I really appreciate your time!! :D

 

[Alex Blakenburg]

You're welcome.
The main issue was that you had the row and column references reversed.
The syntax is:
=INDEX( table, row_number, column_number )
Also you specified the range as rows 2:5, sales was on row 2 which is row position 1 in the Range 2:5.

The end result is also cleaner if you remove the Sheet reference in front of any cell references that are on the same sheet as the one containing the formula.
eg formula was on SheetB so A3 will assume SheetB without having that in there cluttering up the formula.