common info for multiple cells

[Bluemith]

lets say i have the following info that will always be the same

blue 9
yellow 7
pink 25

and i am making a long list. Is there a way that i can just enter the color and the corosponding number wiill automatically but put in the next cell? and if so, is there a way that i can change blue to 15 in a manor that will change all the blues to 15?

thanks a bunch, blue

[Bryan Hessey]

lets say i have the following info that will always be the same

blue 9
yellow 7
pink 25

and i am making a long list. Is there a way that i can just enter the color and the corosponding number wiill automatically but put in the next cell? and if so, is there a way that i can change blue to 15 in a manor that will change all the blues to 15?

thanks a bunch, blue

Hi,

You need something like a VLookup, where you can setup blue to pink worth 9 to 25 etc, and then relate that with (in B1)

=VLookup(A1,Sheet2!A1:B3,2,False)

where the colours and their related (but changeable) values are stored on Sheet2 etc.

to do this for a column see Formula Fill at
http://www.mvps.org/dmcritchie/excel/fillhand.htm

hth
---