Vlookup for repitative data
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??
|