Excel
Get last word of a cell
=TRIM(RIGHT(SUBSTITUTE(TRIM(B6)," ",REPT(" ",100)),100))
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
Last updated