Hello,

I would like to be able to look up the last 3 values in a row that are not zero from another worksheet.

I am using this formula on my current worksheet - {=+INDEX($AN2:$CH2,SMALL(IF($AN2:$CH2>0,COLUMN($AN2:$CH2)-COLUMN($AN2)+1),1))} and it works like a charm.

However when i try to lookup a value from my current worksheet and extract the last 3 non zero results from another worksheet i am having no luck putting a formula together.

So lets say I want to find the last 3 test scores from a student that are located on a different sheet - how would i do that?

Like i said if the text scores were on the same page the above formula works...i just don't know how to combine match or some type of lookup with this formula to get the result i need.

Any help is appreciated.