This is called a table lookup. Let's put the table in H1 thru I5:

Procedure Code Amounts
PSG 100
PSG CPAP 200
MSLT 300
MWT 400

The table can be very long.

We can put the lookup value in A1:
PSG
In B1 we enter:
=VLOOKUP(A1,H2:I5,2)
and it displays:
100

I hope this response keeps you "happy"

--
Gary''s Student - gsnu200752


"happy" wrote:

Ok, thanks I really appreciate it. (these are just example amounts) I need to
be able to type in a procedure code and the correct amount pop up. Is there a
way to do that?
Procedure Code Amounts
PSG 100.00
PSG CPAP 200.00
MSLT 300.00
MWT 400.00



"Gary''s Student" wrote:

No problem. Just tell us what you are trying to accomplish.
--
Gary''s Student - gsnu200752


"happy" wrote:

would you mind if I gave you an example?

"Gary''s Student" wrote:

For example, we want a cell to have either the value in B1 or C1 depending
upon A1:

=IF(AA1=1,B1,C1)
--
Gary''s Student - gsnu200752


"happy" wrote:

Is there anyway to set up one cell for different variables?