Tech Support Forum - View Single Post

dana · 06-16-2009, 01:20 PM

I'd like to have a specific cell automatically list info based on what gets entered into another field.

Example:

G16 starts with 3 then cell G18=AMEX
G16 starts with 4 then cell G18=VISA
G16 starts with 5 then cell G18=MASTERCARD

I think this might be a conditional format, but I must have brain drain today.

Thanks.

Dana

06-16-2009, 01:20 PM	#1 (permalink)
dana Registered User Join Date: Sep 2003 Posts: 13 OS: xp	EXCEL Auto fill I'd like to have a specific cell automatically list info based on what gets entered into another field. Example: G16 starts with 3 then cell G18=AMEX G16 starts with 4 then cell G18=VISA G16 starts with 5 then cell G18=MASTERCARD I think this might be a conditional format, but I must have brain drain today. Thanks. Dana __________________ Dana