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.

Find more posts tagged with

Accepted answers

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.