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
Related:
 Need help on VLOOKUP
 Transfer data from one excel worksheet to another automatically vlookup  Guide
 Vlookup if cell contains a word within text ✓  Word Forum
 Vlookup if two cells match return value from third ✓  Excel Forum
 Help Please IF & VLOOKUP Returns  Excel Forum
 Vlookup false ✓  Excel Forum
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