This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical calculations, such as multiplying X time Y. We are able to do this in Excel by using the Lookup Function.
Syntax
=LOOKUP(“letter”,range)
Let’s look at the example below. In column “A” we have our letters and in column “B” we have our corresponding values.
We use the formula =LOOKUP(“B”,A2:B10) to pull the value tied to letter “B”. In this case, the value returned is 8.
Multiply/Subtract/Divide etc.
In the example below, we string together two LOOKUP functions to multiply the value of B * C. This can be amended to perform various calculations.
=LOOKUP("B",A2:B10)*LOOKUP("C",A2:B10) Result = 32