Forum Discussion

DFXFIX1's avatar
DFXFIX1
Copper Contributor
Apr 15, 2023

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).

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