formulas

  • Thread starter Thread starter Guest
  • Start date Start date
For example, we want a cell to have either the value in B1 or C1 depending
upon A1:

=IF(AA1=1,B1,C1)
 
would you mind if I gave you an example?

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

=IF(AA1=1,B1,C1)
Click to expand...
 
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
 
How about you give us some examples of what you want to do?


Gord Dibben MS Excel MVP
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for multiple variables. 2
Setting the cell number as a variable 1
Insert info from a cell into text 3
Excel VBA 1
how can we make one constant number to be act as variable 3
multivariable calculations/3d arrays 9
Locking content, formula, and format in a cell 2
Variable Names in Formulas 2

Back
Top