How to find the value of one cell from looking at three columns
Hi everyone I am trying to create a formula where it utilizes three columns to pull a value of one cell from the row.
Ultimately what I am trying to accomplish is create an formula where there are three columns in a report (Year, Month, and Average Amount)
Every month a new row will be added and a formula I am trying to create a formula in a new cell to feed into a dashboard
The Formula will first look for the specific year so for example 2023, and then it will look for the most current month which would be numbered through 1-12. After it finds the row with the most current month it will pull the value from the Average Amount Column every time a new month is added is there a formula that can do this?
This is what I currently have so far
=IF((([year],2023) AND if([month], 11)), [Average_Amount]@[month]row))
Help Article Resources
Check out the Formula Handbook template!