If statement to cross reference different pages with different value

[Tompkins]

Hi,

I'm relatively new to using functions in excel and am trying to get a spreadsheet to cross reference different pages and display different values.

Please Login or Register  to view this content.

That is what i currently have, $F$3 is referencing the year displayed and $D$3 is referencing the Month. I'm having problems with it display the correct information when the years both match. Any help would be greatly appreciated.

Cheers

[FDibbins]

Hi, welcome to the forum

If you are trying to reference different sheets based on certain criteria, you may need to use INDIRECT(). However, I would suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.