Automatic Formula in Google Sheets Using MAP

[@SalAbraham7]

You could have used this formula =map(Table1[department],Table1[salary],LAMBDA(dep,sal, XLOOKUP(dep,Bonus[department],Bonus[bonus_increast],"")*sal))

[@SalAbraham7]

for the new salary, the formula =map(Table1[department],Table1[salary],LAMBDA(dep,sal, (XLOOKUP(dep,Bonus[department],Bonus[bonus_increast],"")*sal)+sal))

[@matttechtidbits]

Both are great - better even. To account for incoming data and readability of which ranges are what. I need to make it more of a habit to use the new table referencing!