1. *array formula*
=OFFSET(Sheet1!$B$6:$C$6,MATCH($C$4,Sheet1!$B$6:$B$55,0),0,5,2)
witten on I6:J10 at one !
2. formula wittten in one cell I5
=$C$4
On Fri, Apr 22, 2011 at 1:47 PM, Jai wrote:
> Attachemtn attached
>
> --
>
--
--
Hi,
Have a look at the attached file. Note than there was a space after « Ram »
on Sheet1. I removed it.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jai
Envoyé : vendredi 22 avril 2011 08:47
À : excel-macros@googlegroups.com
Objet :
