Hello,
I am pretty comfortable with excel formulas but INDEX and MATCH I have never gotten to know very well and think they are what I need here.
In my sample workbook I have two tabs ("NS" and "SAS") where I have listed project tickets in Column A . What I want is that when the Ticket is updated to 'Yes' in column C (titled Approved), that the Ticket will automatically appear on the third tab titled 'Approved'. The end goal is to update the ticket's approval status in the NS and SAS tabs, and have them automatically show on the list of tickets on the Approved tab.
Bookmarks