Cross Sheet References

ljtice

I am trying to create some UAT Testing and Issue Trackers. I have two (2) sheets, one called Tests and one called Issues. As the scenarios in the Test sheets are pre-defined, I would like to be able in the Issues sheet to add the scenario number to the field in the row Issue row but then autopopulate the issue number back in a column on the Test sheet.

Example. Test Sheet with Issue Reference populated from

Issue Log with Scenario field.

In short, I would fill out the Issue sheet first and add the related scenario, which would then autopopulate the Issue 1 column in the Test sheet. I'm not sure why I'm having such a hard time with this.

heyjay

If I understand in correctly, the formula needs to be entered in the column Issue 1 of the Test Sheet.

=Index({SIT #},Match([Test Case]@row,{Scenario},0))

Anything in curly brackets needs to be set as reference.

heyjay

If I understand in correctly, the formula needs to be entered in the column Issue 1 of the Test Sheet.

=Index({SIT #},Match([Test Case]@row,{Scenario},0))

Anything in curly brackets needs to be set as reference.

ljtice

Thanks, I made that work. I'll get the hang of this syntax soon, I hope. However, when I make updates, they don't seem to keep up, I get no match. Is there a lag?