Index/Match/Match help

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!

Join

Accepted answers

ivoller

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

index-match.yxmd

All comments

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!

Capture.PNG

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.

Capture.PNG

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335