Formula - Row Summary

ccisneros

I have 2 different sheets going into one report so I can track benefits/staff adjustment changes through the year. When it comes to renewal time, I would like to be able to pull down the most current information into one row. Is that possible?

Samuel Mueller

@ccisneros Reports with difference sources will always appear on separate lines. There is no way to match up to one row.

You would need a 'matrix' sheet or just a third sheet with cross sheet references to both of your sources. Then you would need a unique identifier or something unique and use an index match formula.

If I did not answer your question, please include some more detail on your situation and I will try to help further.