# Need help on VLOOKUP

Solved/Closed
Siddu - Mar 19, 2010 at 11:04 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 19, 2010 at 01:00 PM
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.

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 19, 2010 at 01:00 PM
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