Advanced INDEX MATCH formula

[nicolepounds2727]

Hello friends

I am in need of an INDEX MATCH formula that looks up one column OR another column. Our group accounts are listed in one column and the accounts that comprise said group account are listed in another column. EG group account 15000 is in column A. 15100, 15200, 15300, 15400... are in column B. In the cells in question some are group accounts (15000) and some are subsidiary accounts (15100). Can I do an OR formula inside the INDEX MATCH formula? I kinda tried to but it didn't work so well. Any help would be greatly appreciated.

Thanks.

 

[DanteAmor]

You can put some sample data of what you have on the sheet. And you must also put what you need as a result.