H
happy
Is there anyway to set up one cell for different variables?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
yes
G
Gary''s Student
For example, we want a cell to have either the value in B1 or C1 depending
upon A1:
=IF(AA1=1,B1,C1)
upon A1:
=IF(AA1=1,B1,C1)
H
happy
Could you give me some pointers on how to do this?
H
happy
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)
G
Gary''s Student
No problem. Just tell us what you are trying to accomplish.
H
happy
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
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
G
Gord Dibben
How about you give us some examples of what you want to do?
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
G
Gary''s Student
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"
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"