Use a Letter to Represent a Value in Excel

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.

Use a letter to Represent a Value in Excel

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
Use a letter to Represent a Value in Excel

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend