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.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives