View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RayportingMonkey RayportingMonkey is offline
external usenet poster
 
Posts: 87
Default Assigning Values to Symbols

Another way to do it is like this...
Setup a sheet as follows:

A B C D E
1 P1 -12.5 P 1
2 P 25 P1 -0.5

The formula in cell B1 is:
=SUM(VLOOKUP(A1,$D$1:$E$2,2,FALSE)*25)

What this does is it looks at the "TableArray" in cells D1:E2 and tries to
find a match to what is entered into cell A1. It will then multiply the
matched value, which resides in column E by 25.

The VLOOKUP will work in a large combination of formulas, allowing you to
define a list of values (TableArray) and use them throughout the sheet!



"George" wrote:

I want to be able to insert symbols such as a letter (p) or a letter and
number (p1)into a worksheet. I then want to created a formula that
recognizes those symbols as a specific value, such as p=1 and p1 -.5. Could
anyone tell me how to do that?

Thanks