Largest value from every other cell and the cell to the right of the large?

[Waboku]

Hello,

I have 2 questions,

How do I get the largest value from a row using only the values from every other cell? Specifically from the cells B2, D2, and F2. I think I can add the other cells I would like to get the large from if I know how that much of it is formatted.

Also, how do i get the value of the cell to the right of the largest value using a function?

I would like to use functions for the above in the 2 cells to the right of the data. Please and thank you for considering my question.

 

[mrshl9898]

Sorry, I missed part of your explaination.

I was going Name qty price qty price etc.

If your data is A:AC i'm assuming A is the name, B:O are prices and P:AC are qty?

If so then use:

=INDEX(A:AC,ROW(A2),MATCH(AE2,A2:O2,0)+14)