Excel

Get last word of a cell

• =TRIM(RIGHT(SUBSTITUTE(TRIM(B6)," ",REPT(" ",100)),100))

• Get Last Word

XLookup Function

• =xlookup("Find value","Lookup Range","Return Range","Not found")

  • Lookup Range and Return Range value must be locked with $ (F4)

• https://exceljet.net/functions/xlookup-function