Can I make an IF reference in another sheet and then Index / Match?
Hi!
I'm trying to make an IF formula that will look to see if a specific type of equipment is ordered, and if the PO has been issued, then move the checkbox to another sheet with Index / Match.
Here's a simpler one without the IF...
=IFERROR(INDEX({2024 GC and Contractor Sheet - Bids Range 1}, MATCH([WBS@row], {2024 GC and Contractor Sheet - Bids Range 2}, 0)), "")
Thanks!
Rose
Best Answer
-
Try an IF/COUNTIFS instead.
=IF(COUNTIFS({Vendor}, @cell = "Gilbarco", {Checkbox}, @cell = 1)> 0, 1)
Answers
-
Are you able to provide some screenshots for context?
-
Sure - I hope this helps...
Source Sheet:
If the Vendor is Gilbarco
And the PO Issued is checked....
In the sheet that will receive the IF / Index / Match
The GVR PO Issued checkbox should populate.
Thank you!
-
Try an IF/COUNTIFS instead.
=IF(COUNTIFS({Vendor}, @cell = "Gilbarco", {Checkbox}, @cell = 1)> 0, 1)
-
Woo hoo! That does the trick thank you so much, Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!