Forum Discussion
DFXFIX1
Apr 15, 2023Copper Contributor
Excel/Formulas and Functions
Using XLOOKUP for employee time sheet
=XLOOKUP($E15,{"PM","BMP","ADM","ACC","CON","TRA"},{200,200,200,200,300,150})*$I15The text refers to work categories and the numbers refer to rates ($/hr).
I want to be able to change numbers by referencing the cells containing these numbers so that I do not have to change the numbers in the formula whenever I change the rates. How can I achieve this?
1 Reply
- LorenzoSilver Contributor