Perhaps..
![]()
=IF(ISNUMBER(SEARCH("SR ",C62)),C62,IFERROR(C62&INDEX(C62:C$461,MATCH("~**",C62:C$461,0)),""))
Perhaps..
![]()
=IF(ISNUMBER(SEARCH("SR ",C62)),C62,IFERROR(C62&INDEX(C62:C$461,MATCH("~**",C62:C$461,0)),""))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks