When I use the following, I place the formula into the Spreadsheet and get the resulting row number.
Range(emailColumn & FirstRow & ":" & emailColumn & LastRow).Formula = "=MATCH(B2,'RosterFileName'!FullName,1)+3"
When I try this function in VBA I get different errors; syntax, compile error...