Define a Value

  • Thread starter Thread starter sagenichole
  • Start date Start date
S

sagenichole

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!
 
And as stated in Pete's answer, you need to setup a table somewhere and then
use a VLOOKUP formula.
 
Back
Top