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