Formula Help

PugsRule

I am trying to write a formula that looks at a column in worksheet 1 and compares to a column in worksheet 2. If they match, populate another column in worksheet 1 with a different set of data shown in another column in worksheet 2. Help :)

Heather Duff

Hi @PugsRule ,

It sounds like Index/Match may be a good option for you. https://help.smartsheet.com/function/index ; https://help.smartsheet.com/function/match

You could do something like this:

=IFERROR(INDEX({Worksheet 2 range you want to display the data of},MATCH([Worksheet 1 column you want to compare data from]@row, {Worksheet 2 range you want to compare data to}, 0)),"")

Note that it will pull the data from Worksheet 2 for the first match, so if there are multiple rows that match the criteria, it will only display the first.

Let me know if this works for you!

Best,

Heather