Previous Topic Next Topic

If Than

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

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