Help on MATCH function
Hi,
I think I might need help with using MATCH but not 100% sure if its the right way to go
I have a sheet with a column named Job Number and another column named Status
I am looking to search for any matches in the job number column and if there is a match AND the status column in this matched row is closed I want to set my initial column status also to be closed.
Hope that makes sense !!
Any help appreciated
Answers
-
Is this all in the same sheet? Or are these different sheets? Generally, it may be better to use COUNTIFS function as follows:
=IF(COUNTIFS({Job Number}, [Job Number]@row, {Status}, [Status]@job) >1, xxx, yyy)
If you want to set the initial column status automatically you can either have a formula to do so (i.e. use "Closed" instead of xxx above) or use workflow - depends on situation.
Hope this helps
Vojtech
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives