Need help on VLOOKUP

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have list of Incident numbers(both Closed and open) in Cloumn A and only open incident numbers in column B. I should be able to filter the rows based on the numbers in coulm B so I can mass close the rest of the incidents.

Can anyone help me please

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
In column C you can have a VLOOKUP or MATCH

Lets say data in Column A starts from Row 2
and data in column B starts from Row 2
then in C2 you can write

=IF(ISERROR(MATCH(A2,B:B, 0)), "Close Incident", "Open Incident")

Idea is if number in A2, is not found in column B, then it is a closed incident. If the number is found then it is open incident.

You can drag this formula down and apply filter to see what needs to be done