I'm trying to make a word equal a price (i.e. CD=$1.25).
I want to do this so that if I type in "CD" Excel recognizes it to be equal
to $1.25

I'm working on putting together a new invoice system at work. Please help me.

Depending on how many unique Text's you want to identify........might use IF
statement or maybe VLOOKUP..........need more info to get specific...

Vaya con Dios,
Chuck, CABGx3






"officedrone" wrote:

I'm trying to make a word equal a price (i.e. CD=$1.25).
I want to do this so that if I type in "CD" Excel recognizes it to be equal
to $1.25

I'm working on putting together a new invoice system at work. Please help me.

I want to have the words in column A to equal the values in column B
A B
DVD w/ Case 1.25
CD w/ Case 1.25
Beta S/P 30 10.00
Beta S/P 60 18.00
Beta S/P 90 24.00
VHS T-15 0.65
VHS T-30 0.85
VHS T-60 0.95

You must create a Table, just as you show in your post. Let's say it's on
Sheet2, in columns A and B just as you show. Then, if on Sheet1 you type
DVD w/Case in cell G1, then put this formula in cell H1 to return the 1.25
value

=VLOOKUP(G1,Sheet2!A:B,2,FALSE)

the only problem is, you must type the entries in G1, EXACTLY as they
appear in the table.

Vaya con Dios,
Chuck, CABGx3



"officedrone" wrote:

I want to have the words in column A to equal the values in column B
A B
DVD w/ Case 1.25
CD w/ Case 1.25
Beta S/P 30 10.00
Beta S/P 60 18.00
Beta S/P 90 24.00
VHS T-15 0.65
VHS T-30 0.85
VHS T-60 0.95

Insert Name/ Define/
name: CD
refers to: =1.25
then if in a cell you type the formula =CD, you'll get 1.25. Format as
currency if you like.
--
David Biddulph

"officedrone" wrote in message
...
I'm trying to make a word equal a price (i.e. CD=$1.25).
I want to do this so that if I type in "CD" Excel recognizes it to be
equal
to $1.25

I'm working on putting together a new invoice system at work. Please help
me.