If Than

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I am looking for a simple formula or macro for an excel spreadsheet. If a value is selected from a drop down list in Cell A and that value is equal to Value A, then I want Cell B to auto populate with Value B and so forth. My drop down list is about 50 numbers and each of those numbers is specific to a value.

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
I can't understand what you are trying to say.......... Any way try to use this below formula ..... first {bracket} will check the value and suppose if you enter 1 then in B column will return the value 30 and 2 then 29 and onward ....hope it will be hlepfull for you

=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,""},{30,29,28,27,26,25,20,15,14,13,12,11,10,5,4,""})