Help getting value to appear
Here is my equation. I am trying to get it to match the columns between two spreadsheets and display a value based on cells matching. It's not giving me an error message and it looks like all the references are correct, but it's not displaying a result.
=IFERROR(INDEX({PVSYST Forecast}, MATCH(1, ([Project Name]@row = {Project Name}) * (Month@row = {Month}), 0)), "")
This is the sheet the equation is on. Asking it to look at these cells...
Then I am asking it to compare to these columns, find a row that has a matching data within Month and Project Name and then to pull the result where we have a match in the row. The result should pull the PVSYST forcast column
Here is where it's supposed to be displaying.
What am I doing wrong? I am sitting here with CHAT GBT for hours trying to figure it out and have tried it all different ways to work.
Best Answer
-
An INDEX/MATCH has a specific format. The formula above is not written in the expected format. The IFERROR is masking the error as you have it written to produce a blank field when errors are encountered.
Try this
=INDEX(COLLECT({PVSYST Forecast}, {Project Name},[Project Name]@row,{Month},Month@row),1)
Kelly
Answers
-
An INDEX/MATCH has a specific format. The formula above is not written in the expected format. The IFERROR is masking the error as you have it written to produce a blank field when errors are encountered.
Try this
=INDEX(COLLECT({PVSYST Forecast}, {Project Name},[Project Name]@row,{Month},Month@row),1)
Kelly
-
I had to make a small adjustment, but I got it to work. You're a lifesaver!!! Thank you! Do you have suggestions on a place I get learn to get better with formulas? @Kelly Moore
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 287 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!