How to pick values

PYI

Hi,

I have two sheets Sheet A , Sheet B,using Index Match i fetch some values from Sheet A to Sheet B.

But i have a problem to fetch latest values ...

Example:

If i select Tester A in sheet B,,, still it shows 1 1 ,,,, i would like to see latest values( 2 2)

Can you pls help me? Thank you for your time.

Paul Newcome

Are you able to add new rows at the top?

PYI

Hi @Paul Newcome , Thank you for the reply,, yes,, i can change my sheet structure.

Paul Newcome

Adding new rows at the top should give you the result you are looking for.

PYI

Hi @Paul Newcome ,,ya ya,,, it gives the result,,,It takes the top value,,, but is thr any other possibility(formula) for the above problem...

Paul Newcome

There is, but it can get complicated and requires helper columns and multiple formulas. The easiest solution is to insert new rows at the top. A form can make that very easy.

PYI

ok fine, Thank you very much for your support...

Paul Newcome

Happy to help. 👍️