Using some database functions in Excel

[CLARKSON PHARMACY]

I need to have Excel displaying specific values in 3 different cells, (say
B2, B3 and B4) whenever I enter a certain value in B1.
for example when I enter "Plavix" in B1, then automatically B2 should show
"75mg", B3 = "30" and B4 = "1 tablet daily".
I know these are functions for a database program such as Access, but do
they work wirh Excel.

Help is appreciated and thanks for those who helped with an earlier
question.

Wally

[Irina]

I need to have Excel displaying specific values in 3 different cells, (say
B2, B3 and B4) whenever I enter a certain value in B1.
for example when I enter "Plavix" in B1, then automatically B2 should show
"75mg", B3 = "30" and B4 = "1 tablet daily".
I know these are functions for a database program such as Access, but do
they work wirh Excel.

Help is appreciated and thanks for those who helped with an earlier
question.

Wally

Use VLookup function,

( third parameter is array's index from where you take value for B2, B3, or B4)

[Gord Dibben]

Wally

You could use the VLOOKUP Function with a table.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html

While you're there check out using Data Validation drop-downs for entering
values to lookup.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

On Tue, 15 Mar 2005 19:58:33 GMT, "CLARKSON PHARMACY"
<CLARKSON.PHARMACY@VERIZON.NET> wrote:

>I need to have Excel displaying specific values in 3 different cells, (say
>B2, B3 and B4) whenever I enter a certain value in B1.
>for example when I enter "Plavix" in B1, then automatically B2 should show
>"75mg", B3 = "30" and B4 = "1 tablet daily".
>I know these are functions for a database program such as Access, but do
>they work wirh Excel.
>
>Help is appreciated and thanks for those who helped with an earlier
>question.
>
>Wally
>