Excel/Formulas and Functions

Using XLOOKUP for employee time sheet =XLOOKUP($E15,{"PM","BMP","ADM","ACC","CON","TRA"},{200,200,200,200,300,150})*$I15 The text refers to work categories and the numbers refer to rates ($/hr). ...