Urgent help with formula.

Copper Contributor

Hi there, I have been stuck for days trying to figure out a seemingly very simple task. Help would be greatly appreciated!!!

 

In 'column S', I am trying to make every 24 rows fill with the data found in 'Column K' in the following trend = 

 

First 24 rows i.e. each row with ID (Column P) of '1', should be filled with value '49.85' found in 'Column K'. 

 

Then each row with ID '2' should be filled with value '102.03' from 'Column K', and so forth. 

 

I have absolutely no idea. 

 

Thanks for any help!image_2022-12-14_144346362.png

2 Replies

@TimeToAscend 

In S3:

=VLOOKUP(P3,$I:$K,3,FALSE)

or

=XLOOKUP(P3,$I:$I,$K:$K)

Fill down.

@Hans Vogelaar 

 

Greatly appreciated!