Hi all, Is it possible with the following formula to change it so, that it can be used to look for results not only in sheet "alfa" but also in "bravo", "charlie" and "Delta"? =IF(B275="employee:","",VLOOKUP(INDEX(alfa!$D$6:$IV$5000,MATCH(B275,alfa!$B$6:$B$5000,0),MATCH(LOOKUP(2,1/($B$6:B275="employee:"),$C$6:C275),alfa!$D$5:$IV$5,0)),IMPORT!$G$3:$K$300,2,FALSE))

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Index Match over Multiple Sheets

Thread starter mucah!t
Start date Apr 21, 2011

mucah!t

Well-known Member

Apr 21, 2011

Hi all,

Is it possible with the following formula to change it so, that it can be used to look for results not only in sheet "alfa" but also in "bravo", "charlie" and "Delta"?

Code:

=IF(B275="employee:","",VLOOKUP(INDEX(alfa!$D$6:$IV$5000,MATCH(B275,alfa!$B$6:$B$5000,0),MATCH(LOOKUP(2,1/($B$6:B275="employee:"),$C$6:C275),alfa!$D$5:$IV$5,0)),IMPORT!$G$3:$K$300,2,FALSE))