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
-
Are you able to add new rows at the top?
-
Hi @Paul Newcome , Thank you for the reply,, yes,, i can change my sheet structure.
-
Adding new rows at the top should give you the result you are looking for.
-
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...
-
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.
-
ok fine, Thank you very much for your support...
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!