Prev: can't save changes to workbook; ready only
Next: Change listbox text size in Excel 2007
From: peterh on 19 Jan 2010 23:58
I have a worksheet that has 9 suppliers names in (C4:L4), there costs for a
item in (C19:L19) I want to bring the cheapest suppliers name into cell M4.
Need Help!
From: Jacob Skaria on 20 Jan 2010 00:06
Peter, I remember I replied to your post yesterday. Didnt you tried that ?

=INDEX(C4:L4,MATCH(MIN(C19:L19),C19:L19,0))

--
Jacob


"peterh" wrote:

> I have a worksheet that has 9 suppliers names in (C4:L4), there costs for a
> item in (C19:L19) I want to bring the cheapest suppliers name into cell M4.
> Need Help!
From: peterh on 20 Jan 2010 00:38
Jacob,

Thanks that's great, I missed your reply yesterday.

"Jacob Skaria" wrote:

> Peter, I remember I replied to your post yesterday. Didnt you tried that ?
>
> =INDEX(C4:L4,MATCH(MIN(C19:L19),C19:L19,0))
>
> --
> Jacob
>
>
> "peterh" wrote:
>
> > I have a worksheet that has 9 suppliers names in (C4:L4), there costs for a
> > item in (C19:L19) I want to bring the cheapest suppliers name into cell M4.
> > Need Help!
 | 
Pages: 1
Prev: can't save changes to workbook; ready only
Next: Change listbox text size in Excel 2007