Hello all,
I have a excel sheet which allows me to select a rep in cell G2 and then I use Index/Match formulas to help me find all the data on that person. The problem i am having is that my index formulas are not working correctly. Either it gives me N/A# or wrong info.
Here is my formula:
=INDEX(Sheet1!A$2:A25,MATCH($G$2,Sheet1!$B$2:$B$250,0))
I have attached my excel sheet as well.
Thanks
Bookmarks