Hello every One
I want to help my professors in making the Range of this equation dynamic and without Spaces so that when choosing lists of Areas I see all items without spaces from Data Validation
I want to help my professors in making the Range of this equation dynamic and without Spaces so that when choosing lists of Areas I see all items without spaces from Data Validation
Code:
=INDEX(Data!$B$2:$Y$46,,MATCH($B3,Data!$A$2:$A$42,0))
Attachments

13.5 KB Views: 4
Last edited by a moderator: