Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

How to Track movement of Duplicate Code from One sheet to another one.

I have 2 sheets 1st is Asset Master sheet and 2nd is Material Movement sheet. An index match formula is implemented on Material movement sheet to get data from Asset Master sheet like Asset code, Asset name, Asset description. However there another Index match formula applied on the 1st sheet i.e. Asset Master sheet to get other details from Material Movement sheet. There is an case for circular reference but its been tackled. There are more than one asset code present in the Material movement sheet, which makes it difficult to fetch the latest Asset code and populate in the 1st sheet i.e. Asset Master sheet. The Index Match Formula is applied on first data of that particular Asset Code on the Material Movement sheet. My question is, How do we get the latest information using the Index match formula of the same Asset code.


Attach 2 pictures one of 2nd sheet Material movement where there are 2 transaction of the same asset code where the latest " To Location" is km but the formula is only fetching the older data of the same asset code of "To Location" i.e. My home on the Asset Material sheet which been circled with blue color.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions