Match / IF Function

**elfiky** · 09-22-2010, 03:49 AM

I have 3 different quotes. I want to create a formula to reflect $ of the SELECTED quote/option. Please sample file attached. Thanks

**asha3010** · 09-22-2010, 04:29 AM

I have updated the formula in the attached file..
Asha

**TMS** · 09-22-2010, 04:33 AM

H5: =IF(ISERROR(INDEX($D5:$F5,,$G5)),0,INDEX($D5:$F5,,$G5))

and drag down

Regards

**ndkido** · 09-22-2010, 05:15 AM

Even simpler formula... see attached.

**TMS** · 09-22-2010, 05:54 AM

You know what? I've really got to start thinking "Excel 2007" ... Excel 2007 Functions!

Regards

Re: Match / IF Function