Finding the column and their values

Hi,

I have a sheet name "sheet2" in which Row No 1 contains the string and Row 2 contains the string value. And In the sheet3 answers are there. Now I have to do:-

EG :- First It find the Gender into the sheet 3 and and if it finds then lookup the value of Row 2 into that column where Gender finds.


I am attaching a file for your reference.

I don't understand the problem at all.

Is row 2 of sheet2 the desired result? What logic did you apply in generating it?

Hello Yogesh,

Are you looking to count occurrences in each category? Gender, Age, office. If so use this in B3, copy across.

=COUNTIF(INDEX(Sheet3!$A:$C,0,MATCH(B$1,Sheet3!$A$1:$C$1,0)),B$2)