Tech Support Forum - View Single Post

**macropod** · 06-16-2009, 06:06 PM

Hi Dana,

Using a lookup table is often the best approach but, provided there's no more than 8 possible outcomes, you can also do it with a set of up to 7 nested IF tests in G18:
=IF(G16=3,"AMEX",IF(G16=4,"VISA",IF(G16=5,"MASTERCARD","N/A")))

06-16-2009, 06:06 PM	#2 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 559 OS: Vista	Re: EXCEL Auto fill Hi Dana, Using a lookup table is often the best approach but, provided there's no more than 8 possible outcomes, you can also do it with a set of up to 7 nested IF tests in G18: =IF(G16=3,"AMEX",IF(G16=4,"VISA",IF(G16=5,"MASTERCARD","N/A"))) __________________ Cheers macropod (MS MVP -Word)