Arrange values in specific cells based on values

Hi all

What I need to achieve is to assign a series of numbers to corresponding cells based on their values. Does anyone know how to achieve this?

Example... Let's say I have the numbers 1, 4 ,8 and 10. And I need to place these numbers in a column where the number one will correspond to Day 1, number 4 to Day 4, 8 to Day 8, and 10 to Day 10.

Originally Posted by Glenn Kennedy

4. I do not understand what you want to happen. What do you expect to see? Where do you expect to see it? A sample sheet (yellow banner - top of this page) helps enormously.

Hmmm... I don't know how to explain it more clearly. I have random values that I want to appear to the corresponding Day number. If the number is 3, it needs to go next to Day 3. If the number is 10, it needs to go next to Day 10, and so on...

Please see sample attached.

"Sample.xlsx"

Originally Posted by tanasedn

Maybe this?

Formula:

Please Login or Register  to view this content.

I've tried this one but it seems that the numbers are not matching the day numbers.

Originally Posted by Glenn Kennedy

Perfect. Now I understand!!

=IFERROR(INDEX(H:H,MATCH(ROW()-ROW(C$4)+1,H:H,0)),"")

In C4, copied across and down.

Thanks, Glenn. That's exactly what I was looking for.

Cheers!