• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

In Pairs Data Cell

stormania

Member
Hi ..
Kindly help, how to find and a put in pairs data/related in one row ? and put the month ?
As per attach file

Thank you
 

Attachments

  • In pairs data.xlsx
    13.8 KB · Views: 2
Hi,
If your input is the percentage "INFULL", and you would have that value multiple times in your data table, which result do you want to fetch?

Else try
[Q2]= INDEX($C$2:$P$2,,MATCH(Q4,$C$4:$P$4,0))
[R4] = INDEX($C$4:$P$4,,MATCH(Q4,$C$4:$P$4,0)+1)
 

Attachments

  • In pairs data.xlsx
    9.7 KB · Views: 3
Hi,
If your input is the percentage "INFULL", and you would have that value multiple times in your data table, which result do you want to fetch?

Else try
[Q2]= INDEX($C$2:$P$2,,MATCH(Q4,$C$4:$P$4,0))
[R4] = INDEX($C$4:$P$4,,MATCH(Q4,$C$4:$P$4,0)+1)


Thanks so much, its WORKS :)
 
Guido
Does this work? I have replaced SEQUENCE functions by array constants in the hope that it might.
The cunning plan was to devise a formula that would reduce the alternating pattern to a column array.
 

Attachments

  • In pairs data (PB).xlsx
    10.7 KB · Views: 5
Back
Top