Forum Discussion
Multiplying values
Evening all, I want to figure out a function to use to calculate a value using a value given and multiply that dependant on the 'zone' so zone 1 needs to be multiplied by 14.8 zone 2 by 14.8 zone...
Create a range with zones in the first column and the corresponding multiplication factors in the second column.
In the screenshot below, this is E2:F7.
You can then use XLOOKUP (or VLOOKUP) to retrieve the factor for a specific zone:
The formula in C2 is
=A2*XLOOKUP(B2, $E$2:$E$7, $F$2:$F$7)