If cell equals this, then insert cell

lmaccabee

Hello,

I am looking to auto populate a cell with some information pulled from another sheet.

So if Site Name equals 'Bury', Contract ID should populate with '0004' from other sheet.

I'm struggling to find the correct formula in order to do this, if somebody would be kind enough to help please.

Kelly Moore

Hey @lmaccabee

Since you are only looking at one criteria, an Index/Match should work for you.

Because this is a cross sheet reference (different source sheet) you will need to physically insert the references through the formula INSERT REFERENCE link. You cannot simply copy paste.

=INDEX({your source sheet Contract ID column}, MATCH([Site Name]@row, {your source sheet Site Name column},0))

Does this work for you

Kelly

Kelly Moore

Hey @lmaccabee

Since you are only looking at one criteria, an Index/Match should work for you.

Because this is a cross sheet reference (different source sheet) you will need to physically insert the references through the formula INSERT REFERENCE link. You cannot simply copy paste.

=INDEX({your source sheet Contract ID column}, MATCH([Site Name]@row, {your source sheet Site Name column},0))

Does this work for you

Kelly

lmaccabee

@Kelly Moore

Thank you very much - this worked perfectly.

😊