formula

[pripin8891]

hello,


can anyone answer the link below?


http://www.fileconvoy.com/dfl.php?id=g08412badfabc72a9999284660a4e9083f1180fec5


thanks

 

[oldchippy]

Hi pripin8891,


Welcome to the forum, is this what you require?


=VLOOKUP(F2,$A$2:$B$9,2)

 

[NARAYANK991]

Hi ,


Your requirement is not clear from your file ; can you explain whether you want the different values of code 101 to appear one after another ?


Your codes are in the range A2:A9 , while the values are in B2:B9 ; if you want these different values to appear in column G , then in G2 enter the following formula , as an array formula , using CTRL SHIFT ENTER :


=INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=$A$2,ROW($A$2:$A$9)-MIN(ROW($A$2:$A$9))+1),ROW(A1)))


Copy this down to G3 , G4 , G5 ,...


Narayan

 

[pripin8891]

hello,


thanks for ur response.

code 101H has values in B2,B4,B6,& B8 .

and i want to update these values in G3,G4,G6,G7 so that B2 value appear in G3,

B4 value appear in G4, B6 in G6 & B8 in G7.


i applied index & small if you have given but not working.


thanks

 

[NARAYANK991]

Hi ,


Sorry , I had not understood your requirement ; try this :


=INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=F2,ROW($A$2:$A$9)-MIN(ROW($A$2:$A$9))+1),COUNTIF($F$2:F2,F2)))


Enter it as an array formula in G2 ( using CTRL SHIFT ENTER ) , and copy downwards.


BTW , you have more 101 codes in column F than you have in column A.


Narayan

 

[pripin8891]

great!!!


thanks