Google Sheets formula for – if range contains text then return cell address that contains

I’m trying to make formula that will return last symbol of cell that contains specific word.
For that i need get cell address.
=IF(COUNTIF(B$3:V$23; CONCATENATE(B27; "*")); RIGHT(B$3:V$23); 0)