Excel-2013 Excel

[Harishmd80]

Hi,
Need help, Please help me as mentioned in attached file.

Regards

Harish

 

[eibi]

Try this formula in Cell H3, drag to fill.

=IF($D3>H$1,$F3,$B3)&" "&H$2

(see attached).

 

[Harishmd80]

Try this formula in Cell H3, drag to fill.

=IF($D3>H$1,$F3,$B3)&" "&H$2

(see attached).

Hi Eibi,

Thank you for help, but what I was looking that grid% should take from Grid% tab based on level & rating from respective table ( IDC or BPO).

Regards
Harish

 

[bosco_yip]

Try,

Data sheet H3, formula copy across and down :

=LOOKUP(9.99E+307,CHOOSE(MATCH(IF($D3>H$1,$F3,$B3),{"IDC","BPO"},0),VLOOKUP($E3,'Grid%'!$A$4:$F$10,MATCH($C3,'Grid%'!$A$3:$F$3,0),0),VLOOKUP($E3,'Grid%'!$A$17:$F$20,MATCH($C3,'Grid%'!$A$16:$F$16,0),0)))

Or another option,

=INDEX(('Grid%'!$A$4:$F$10,'Grid%'!$A$17:$F$20),MATCH($E3,CHOOSE(MATCH(IF($D3>H$1,$F3,$B3),{"IDC","BPO"},0),'Grid%'!$A$4:$A$10,'Grid%'!$A$17:$A$20),0),MATCH($C3,CHOOSE(MATCH(IF($D3>H$1,$F3,$B3),{"IDC","BPO"},0),'Grid%'!$A$3:$F$3,'Grid%'!$A$16:$F$16),0),MATCH(IF($D3>H$1,$F3,$B3),{"IDC","BPO"},0))

Regards
Bosco