Index/Match/Match help

[Adara]

Hi everyone!

Complete newbie here trying to learn how to supplement contact information to a master sheet that is already partially filled out. Both sheets have the unique identifiers. All other examples I have found in the community are somewhat useful but glance over information I don't know yet.

Please and thank you!

[ivoller]

Hi,

Generally speaking the functionality to replace Index/Match is via the Join tool. If you can give an example of what you are trying to match I can provide more details.

Also, if you right click on the Join Tool and choose 'Open Example' you'll get a good idea of how it works.

Cheers,

Iain

[Aguisande]

Hi @Adara

Can you provide a little more detail on your use case?

Maybe writing named ranges, or joining data together may help..

Best,

_AG_

[Adara]

Hi Ian,

The master sheet is attached as an image, and I am trying to supplement from another sheet that had the same headers and fill in the null values on my master sheet without losing current data.

And I had no idea that function existed on the tools, thanks!

[Adara]

The master sheet is attached as an image, and I am trying to supplement from another sheet that had the same headers and fill in the null values on my master sheet without losing current data.

For example, replacing the Category null values with the content from another sheet.

[ivoller · Accepted solution]

Hi,

See attached workflow for an example that I think meets the need. Basically new records will be used to replace data for null fields in the master data. If you have a lot of fields there are other ways to achieve this but this should get you started i think.

Cheers,

Iain

[Adara]

Thank you Iain!

This is a super helpful starting point. I had figured out it would be necessary to use Join and Union but couldn't organize it with the filter correctly.

Cheers!