Formula that results in data input moving down a column based on another column cell data

[gammoneer2b]

I am looking for a formula(s) in Col.3 (or other methods) to produce a result in Col. 3 from using the #s in Col.1 and Col. 2
The formula would result in copying the Col.2 ID#s to auto populate (the specified Col.1 number of times) inputted sequentially from top of Col.3 moving downward.

The formula would possibly be in Col. 3 and would result in taking the first ID# “#3” (in top of Col. 2) to appear 2 times moving downward from top of Col.3. Immediately after the top two #3s in Col. 3 would come three sets of the ID# “#4” and then immediately thereafter moving downward would come 4 sets of the ID# “#7” and then finally 1 set of the ID# “#11”.

It seems to me it would be easy in VBA but I am looking for an EXCEL formula or other things to use in EXCEL spreadsheet without use of VBA.

I have thought about VLOOKUP or OFFSET functions and possibly a COUNTIF but nothing seems to work for me. Anyone have any solutions please?

Col.1 Col.2 Col.3
Result of first 2 columns
2 #3 #3
3 #4 #3
4 #7 #4
1 #11 #4
#4
#7
#7
#7
#7
#11

[gammoneer2b]

Sorry the columns did not line up correctly in previously posted text.
Here attached is an example of EXCEL spreadsheet for what I am looking for

[Limor_OP]

Hi,

For some reason I'm getting an access denied blocking alert when trying to post my reply to this thread.

This is what I'm getting:
"Your request was not authorized due to its content (HTML code not allowed)."

I only attached the file , I couldnt copy the formula in the text message.

[AliGW]

The error message tells you what the problem is!!! Something in your reply was being seen as HTML.

Here's your formula:

=IF(COUNTIF($C$2:C2,C2) < INDEX($A$1:$B$5,(MATCH(C2,$B:$B,0)),1),C2,INDEX($A$1:$B$5,(MATCH(C2,B:B,0))+1,2))

Note the spaces I've added either side of the chevron < so that it's accepted.

[Limor_OP]

Hi AliGW,
Thanks, I wouldnt guess on my own what the problem was. Thanks for your help.