Prev: How do I ensure formulas automatically calculate after pasting
Next: Formulas
From: sagenichole on 18 May 2010 08:59
Thank you to those who posted to my question earlier, but just to give a
little more insight on what I am trying to do:
I have a scroll list in one cell and I am trying to make it where if I
select one thing from that scroll list the cell next to it will auto populate
with a number I define. However different things on the scroll list will
need to equal different values.

Please Help!!

Thanks!
From: T. Valko on 18 May 2010 09:32
See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"sagenichole" <sagenichole(a)discussions.microsoft.com> wrote in message
news:00940793-2408-4B89-9D48-39E190E629AD(a)microsoft.com...
> Thank you to those who posted to my question earlier, but just to give a
> little more insight on what I am trying to do:
> I have a scroll list in one cell and I am trying to make it where if I
> select one thing from that scroll list the cell next to it will auto
> populate
> with a number I define. However different things on the scroll list will
> need to equal different values.
>
> Please Help!!
>
> Thanks!


From: Luke M on 18 May 2010 09:41
And as stated in Pete's answer, you need to setup a table somewhere and then
use a VLOOKUP formula.

--
Best Regards,

Luke M
"sagenichole" <sagenichole(a)discussions.microsoft.com> wrote in message
news:00940793-2408-4B89-9D48-39E190E629AD(a)microsoft.com...
> Thank you to those who posted to my question earlier, but just to give a
> little more insight on what I am trying to do:
> I have a scroll list in one cell and I am trying to make it where if I
> select one thing from that scroll list the cell next to it will auto
> populate
> with a number I define. However different things on the scroll list will
> need to equal different values.
>
> Please Help!!
>
> Thanks!


 | 
Pages: 1
Prev: How do I ensure formulas automatically calculate after pasting
Next: Formulas