Match and index

[RichPee]

Hello,

I am trying to use the Index and Match functions combined but the value keeps returning #N/A.

The example I've attached is a lot smaller than the document I am using hence the need for this function (if it is the right one to use).

Each month I want to copy the values from another document into the tab P&L Forecast. I then want the tab P&L Trend to pull the information I want to see and in the format I prefer.

The current formula on the P&L Trend tab in cell c6 is what I've tried. I basically want a formula that will recognise the row in this case 'Food' and the column in this case 'January' and go and find the value on the P&L Forecast tab. All examples I've found do not show either how to do a selection of Months instead of just putting C1 for the month. Ideally I'd want C1:O1.

Is this possible?

THANK YOU

[Glenn Kennedy]

In C6, copied across:

=IFERROR(INDEX('P&L Forecast'!$B$3:$L$10, MATCH('P&L Trend'!$A6,'P&L Forecast'!$A$3:$A$10,0), MATCH('P&L Trend'!C1, 'P&L Forecast'!$B$2:$L$2,0)),"")

[Glenn Kennedy]

I also changed row 1 of trend to be dates... not month names and then formatted the date to look like a month name.

[RichPee]

You Glenn are awesome! This solved it perfectly. Thank you

[Glenn Kennedy]

You're welcome.