Always pull in the value from the same cell

Stéphane Charbonneau

I'm trying to pull in a text value form a 2nd sheet. The value I'm trying to pull will always be in cell [TextToPullIn]1 for example. That second sheet is populated by a form with the latest entry always on top, and the text I want to pull in my first sheet will therefore always be in the same cell. Any ideas? Maybe I'm thinking too hard... Thanks.

Genevieve P.

Hi @Stéphane Charbonneau

We could use an INDEX(MATCH formula to search for the newest submission, then return the value from a different column. The way to do this would be to add in a System Column to populate the Date Created in your source sheet where the forms come in.

Then we can use the MAX function to find the oldest date (most recent date), which will tell the formula what row to look into.

In my example, Range 1 is the column in tour source sheet with the text value you want to be returned.

Rage 2 is the Created Date System column.

(These are both Cross Sheet References.)

Try something like this...

=INDEX({Text Value - Range 1}, MATCH(MAX({Created - Range 2}), {Created - Range 2}, 0))

Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi @Stéphane Charbonneau

We could use an INDEX(MATCH formula to search for the newest submission, then return the value from a different column. The way to do this would be to add in a System Column to populate the Date Created in your source sheet where the forms come in.

Then we can use the MAX function to find the oldest date (most recent date), which will tell the formula what row to look into.

In my example, Range 1 is the column in tour source sheet with the text value you want to be returned.

Rage 2 is the Created Date System column.

(These are both Cross Sheet References.)

Try something like this...

=INDEX({Text Value - Range 1}, MATCH(MAX({Created - Range 2}), {Created - Range 2}, 0))

Let me know if this works for you!

Cheers,

Genevieve

Stéphane Charbonneau

Oh, I see... INDEX(). Thanks ;)

Genevieve P.

No problem!