I have a tab that has 90K+ IDs in a "Summary" tab. The details related to these IDs are in two different tabs. One tab has the names of Group Insurance Participants and the other tab has the names of the Individual Insurance participants. I want to write a formula in the cell next to the ID showing whether the ID belongs to Group or Individual.
I wrote a "vlookup" formula and looked for the ID in Group tab. If the ID matched, I called it "Group" and if the error occurred I called it "Individual"
The problem is there are IDs that don't exist in either tab. How do I solve this simple issue?
This is the kind of end result I am looking for:
Thank in advance.
Any help is greatly appreciated.
I wrote a "vlookup" formula and looked for the ID in Group tab. If the ID matched, I called it "Group" and if the error occurred I called it "Individual"
The problem is there are IDs that don't exist in either tab. How do I solve this simple issue?
This is the kind of end result I am looking for:
Thank in advance.
Any help is greatly appreciated.