How to pick values

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!