Find max row and return corresponding value

I would like a bit of help with the following problem....

I would like to find the last entry of 0 in the colums marked run counter A..F
I would then like the corresponding value from the Settings columns A..D, entered under the Process columns.
eg, process A, has a 0 in cell F7, so row 7. The corresponding values for this are located in cells A7 and B7 (as per my page).
for process B, the row number is 8 (but could be 2 or 9, there is no regimented order), so would require the settings values in cells A8 and B8.

I would like to add an automatic function into the cells A3..M6 to complete this operation, noting that process F has 4 settings as opposed to 2.

I have attached a copy of part of my spreadsheet page to make this a little clearer.

I hope you can help. Thanks.

Hi Gav

Will something like this help you?

Gavsterv1.xls

you have managed to confuse things nicely with calling labeling your columns a,d,c,d,e,f
is this what you want?

In M3

=INDEX(INDEX($A$3:$D$12,,ROW(A1)),MATCH(0,F$3:F$12,0))

Copy down and across

op did say

I would like to find the last entry of 0

implying there may be more that one

I'm not at all sure what you are doing with columns C and D but this will find the 0 in columns F, G, and H and return the values in columns A and B that match the row where the 0's are.

Formula:

Please Login or Register  to view this content.

Enter with Ctrl + Shift + Enter

For the values in row 4 under the above values use this VLOOKUP

Formula:

Please Login or Register  to view this content.

Originally Posted by gavster

Thanks guys for the quick responses, and apologies for not getting back to this sooner.

The solutions put forward by TheCman81 and martindwilson appear similar and both appear to work for me.

Thanks for the other replies, this forum is sooo helpfull to idiots such as myself. Maybe oneday I can return the favour when I finally understand excel!!

Thanks agin,
Gavin

Glad to help and thanks for the feedback