Need a formula to get the Industry PE data ?

[SONJOE JOSEPH]

Dear Excel Experts,

In the attached excel sheet i have two sheets named Data and Industry PE. In the Industry PE sheet i have given the Industry PE of each specific sectors. But in the data sheet in the M column u will see Ind PE downwards all the data's are blank. I'm looking for a formula were by i can fill the Ind PE data using the industry PE sheet .

Eg. for Bergerpaint its sector is Building materials so Ind Pe 42.52
Dabur its sector is Consumer Goods so Ind Pe 46.86
Marico its sector is Consumer Goods so Ind Pe 46.86
Dhanuka its sector is Agro Chemicals so Ind Pe 37.14

Hope now u guys understood the flow. Kindly send me the formula at the earliest.

Regards,

Sonjoe
Sample file attached

 

[ETAF]

=INDEX('Industry PE'!$C$4:$C$32,MATCH(Data!C4,'Industry PE'!$B$4:$B$32,0))

 

[SONJOE JOSEPH]

=INDEX('Industry PE'!$C$4:$C$32,MATCH(Data!C4,'Industry PE'!$B$4:$B$32,0))

Thank you dear...its working fine

 

[ETAF]

you are welcome, having issues with saving excel - not sure whats going on there . anyway glad just posting the formula worked ok