how do i use "if" in cell that ref another with text from a pulld.

[Guest]

I am trying to create a what if scenario. I have cell A8 that is linked to a
combo box, which is linked to N4:N15 where I am using text. I want a number
to be placed in cell C8 based on what cell A8 is in the combo box. How do I
manage this, or can I?

John

 

[CLR]

Sounds like a job for VLOOKUP............

In cells O415, put the numbers you wish to shoe\w up when each stxt value
in N4:n15 is called up in A8 .................
Then, in C8, put this formula.........

=VLOOKUP(A8,N4:O15,2,FALSE)

Then, whatever value is selected in A8, the corresponding number will appear
in C8.......


Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Each item in the drop down (combo box) has a differnt value to it.