P
Peter
Is there any way of getting around the 7 or 8 limit that the IF formula
statement sets. Any help appreciated.
Pete.
statement sets. Any help appreciated.
Pete.
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.
D
Don Guillett
Lots of ways such as lookup tables, etc. What do you want to do?
P
Peter
It is a sheet I have for keeping a record of variuos medications. So, when I
enter for example, Diovan in cell C1, the RX number which is for example
123456, will appear in cell D1. Trouble is, I have about 14 different
medications, and the IF statement I have been using allows only 8.. Hope
this makes sense.
Thanx.
Pete
**********
enter for example, Diovan in cell C1, the RX number which is for example
123456, will appear in cell D1. Trouble is, I have about 14 different
medications, and the IF statement I have been using allows only 8.. Hope
this makes sense.
Thanx.
Pete
**********
G
Gord Dibben
Peter
Usually there is another way to do what you want. VLOOKUP, MATCH, CHOOSE or
similar.
Perhaps if you described what you are doing you could get an alternate.
But, to answer your question. Yes, there is. See Chip Pearson's method.
http://www.cpearson.com/excel/nested.htm
Gord Dibben XL2002
Usually there is another way to do what you want. VLOOKUP, MATCH, CHOOSE or
similar.
Perhaps if you described what you are doing you could get an alternate.
But, to answer your question. Yes, there is. See Chip Pearson's method.
http://www.cpearson.com/excel/nested.htm
Gord Dibben XL2002
G
Gord Dibben
Peter
VLOOKUP wil handle that.
Basic example.....
Enter your medications down column A
Enter the corresponding RX numbers down Column B
In D1 enter =VLOOKUP(C1,$A$1:$B$14,2,FALSE)
Now enter a name in C1. Result in D1 will be the RX number.
To make for less typing in C1........
Select C1 then Data>Validation>Allow>List. Select the A1:A14 Range. Check
"ignore blanks" and "in-cell dropdown" then OK your way out.
C1 will now have a dropdown list to pick the medications from.
You can hide Columns A and B if wish to.
Your ranges and columns may vary.
Gord Dibben XL2002
VLOOKUP wil handle that.
Basic example.....
Enter your medications down column A
Enter the corresponding RX numbers down Column B
In D1 enter =VLOOKUP(C1,$A$1:$B$14,2,FALSE)
Now enter a name in C1. Result in D1 will be the RX number.
To make for less typing in C1........
Select C1 then Data>Validation>Allow>List. Select the A1:A14 Range. Check
"ignore blanks" and "in-cell dropdown" then OK your way out.
C1 will now have a dropdown list to pick the medications from.
You can hide Columns A and B if wish to.
Your ranges and columns may vary.
Gord Dibben XL2002