pull information if columns match

BrigitteM

Hi smartsheet community!

I would like to pull a value into a sheet from another sheet if the email address matches

sheet 1: source sheet

if 'email address' on sheet 1 matches 'created by' on sheet 2, I would like to pull the field 'Name' into sheet 2

=IF({2024 L&D Budget Source Range 1} = [Created By]@row, {2024 L&D Budget Source Range 2})

I tried above formula and it returned invalid operation

Mark.poole

@BrigitteM

In Sheet 2.

=INDEX({Name ref}, MATCH([Created By]@row, {Email ref}, 0))

Mark.poole

@BrigitteM

Or you could just copy and paste this based on the references you posted.

=Index({2024 L&D Budget Source Range 1}, Match([Created By]@row, {2024 L&D Budget Source Range 2}, 0))