Perhaps

=IF(Data!$E48="",0,IF($G48="NA",IF(ISNUMBER(MATCH(Data!$E48,Profiles!$B$5:$B$10,0)),INDEX(Profiles!$B$5:$O$10,MATCH(Data!$E48,Profiles!$B$5:$B$10,0),LOOKUP(RIGHT($D48,2)+0,{10,11,12,13,14},{12,11,10,9,8})),""),IF(ISNUMBER(MATCH(Data!$E48,Profiles!$B$15:$B$19,0)),INDEX(Profiles!$B$15:$O$19,MATCH(Data!$E48,Profiles!$B$15:$B$19,0),LOOKUP(RIGHT($D48,2)+0,{10,11,12,13,14},{12,11,10,9,8})),"")))
you may have to adjust ranges again to suit