Help with formula..in column B
trying to lookup the dept (A column) and compare new dept (E column), if match use dept in F column
if not in the E, then use existing dept (A column)
the formula should returned the same info as C column.
sample file is attached
thx
Bookmarks