Asfandyar Ali
Member
Hello respected members. sorry folks, i couldn't post in default forum as im new so posting here.
i need help in extracting data using index match and countifs function. if i use below formula it gives me result from hidden cells also. i need result applied only on visible cells.
=INDEX(Sheet2!A:A,MATCH(1,COUNTIFS(Sheet1!A8,Sheet2!C:C,Sheet1!$B$1,Sheet2!B:B),0))
Please see example worksheet as an example. Need urgent help please. Thanking you in advance.
i need help in extracting data using index match and countifs function. if i use below formula it gives me result from hidden cells also. i need result applied only on visible cells.
=INDEX(Sheet2!A:A,MATCH(1,COUNTIFS(Sheet1!A8,Sheet2!C:C,Sheet1!$B$1,Sheet2!B:B),0))
Please see example worksheet as an example. Need urgent help please. Thanking you in advance.
