hi there. i cant figure out how to do an "if - then" type of function. If A1=
23 then B2= Red
or,
if A1= Blue then B1= Color

wheere i have a list of datat that can be chosen for A1 and then a
corresponding list of data for B2. the B2 cell will be automatically
populated once i fill in A1.

am i asking this right? does anyone know or have a moment to help? thanks!!!!