Okay I've been searching on how to do this and I'm just not getting it correct. This webpage seems to be doing what I want to do. However my formula isn't coming out right.
Basically I have to sheets. One contains active people and the other contains every ID those people have. So the other sheet would have multiple rows of the active people each containing a different ID for them. I'm only interested in two forms of those ID's. The one's starting with "A" and the ones starting with "B".
Some people do not have any ID and others have an A and B ID and maybe a C or D ID as well. The formula I'm using is:
{=IFERROR(INDEX(Sheet2!H:H,MATCH(1,(A3=Sheet2!A:A)*(Sheet2!H:H="%A%"),0)),"")}
And it's just not working.
On the test sheet, the formula is:
{=IFERROR(INDEX(Sheet2!B:B,MATCH(1,(A2=Sheet2!A:A)*(Sheet2!B:B="%A%"),0)),"")}
Where am I going wrong?
Bookmarks