Hi all,
I have attached a demo file, where as in that sheet there is total 7 sheets in seventh sheet i need to display the adjacent value of the criteria i had there. and want to find the all sheets i.e. all 6 sheets and fetch the data and place in sheet 7.
I tried using indirect and countif function, but it only counts. but i need the adjacent value also.
Bookmarks