Vlookup for repitative data
On Oct 7, 9:57*am, isabelle wrote:
hi,
select range E1:E4
copy this formula in E1
=INDEX(ID,SMALL(IF(Product="Abc",ROW(INDIRECT("1:" &ROWS(Product)))),ROW()))
validate with ctrl + shift + enter
--
isabelle
Le 2011-10-07 09:09, Raju a écrit :
Actually I need a formula
Is there any such formula??- Hide quoted text -
- Show quoted text -
Hey isabelle,
Its really nice one!!!
An array formula I had used few of them but in this one I didn't
understand logic for "ROW(INDIRECT("1:"&ROWS(Product))" what its
actually returning to small function when if condition gets true i.e.
Product="Abc" ??
That would be great if you could tell me the logic
When I enterted =INDIRECT("1:"&ROWS(Product)) into different cell say
"D1" for tesing output what it retuns, it shown "product".
|