Active Member
April 14, 2021
Hi forum friends ,
I tried to repeat value that MATCH and REPEAT
with Index(x:Y, match(x,x;y,0)) but it is not returning the multiple value
need your help on this
what I have to do is
IF value is >= (X) it should return Major first and ALL in next cell, IF value is <= X it should return ALL only
A26: N rows should match with $A$4 : $A$23 and return $B4 times of $D$ 4: $D$23 Value in C26: N rows
please help
Thank you in advance
VIP
Trusted Members
December 7, 2016
Active Member
April 14, 2021
Thank you Mr Anders Sehlstedt,
I need to achieve that ,
1st : IF Row no G 4 value >= 1000 it should return in D4 MAJOR and in D5 ALL ( instead of d we can take b4 if required and can move B4:B23 data to D4:D23) ELSE IF VALUE OF C4 <= 999 It should return ALL
then
2nd : look up A26 and match with A4:A23, if value is exist then it should return D4:D23 value in B26:B...(just like Lookup or index ,match)
for example
if Andhra Pradesh repeats N times (repeat times given in B Column) ,then Major and All also need to repeat N times (each 50 times alternatively )
this is what I need to complete
please help
Thank you in advance
1 Guest(s)