FSA Tip #19 Refer to things with INDEX MATCH

A good spreadsheet should play well with other spreadsheets.

That means if you enter something into one spreadsheet, then you can easily refer to another spreadsheet that has additional information about that same something.

Here’s an example …

Say you are setting up a schedule for all the crops you are going to direct seed.

Each row in your schedule lists a crop and a specific seeding date.

Because crops like arugula or carrots are seeded multiple times over the season, they will be listed multiple times in this schedule.

Each time they are listed you also want to see the seeder settings for that crop.

Now you could type that seeding rate in each row.

Or you could copy paste that information over and over.

Or you could use INDEX MATCH!

I think you should go with INDEX MATCH.

In this tip, we’ll see …

  • How to use the INDEX formula to look up whole ranges in another spreadsheet.
  • How to use the MATCH formula to find the location of a specific item within a list.
  • How to bring INDEX and MATCH together to harness the full power of INDEX MATCH!!!
  • How to use INDEX MATCH to refer to other information about an item in a different spreadsheet.
  • How to set up your direct seeding schedule to refer to seeder settings from another chart.

You can get the spreadsheet from this tip to follow along at home.

What do you want to look up in your spreadsheets?



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s