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)


You want to return a cell address based on an IF statement.

Use the CELL function in your IF results. The ADDRESS function could also be an option.

  • Cell address (Absolute): =if(B1="abc",cell("address",B1),"no match")
  • Cell Column: =if(B1="abc",cell("col",B1),"no match")
  • Cell Row: =if(B1="abc",cell("row",B1),"no match")
  • Address (Relative): =address(B6,B5,4,true)



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.