Previous Topic Next Topic

If Than

Closed
debuski - Apr 27, 2009 at 05:50 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 30, 2009 at 05:04 AM
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 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Apr 30, 2009 at 05:04 AM
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,""})





0