I'm getting an Error - Invalid Value for a formula - Need help

I have Sheet 'A' - which has Office numbers in a Column called Office No. (Column Type - Text/Number)

And I want to get Employee Information in a Column called Employee Info (Column Type - Text/Number)


The Employee Information is in Sheet 'B' which has the following columns

  • Office No. (Primary Column) = Similar info as Office No. in Sheet 'A'
  • Job Title (Column Type - Text/Number) = Which has various titles like PM, Eng, etc
  • Employee Name (Column Type - Text/Number) = Name of the employee based on their office & title

I was able to successfully use the below formula to extract the information, however, when I try to drag it down it gives me "INVALID INPUT" as an error.


=INDEX({Employee Name}, MATCH("PM", {Job Title}, 0), MATCH([Office No.]@row, {Office Number}, 0))


WHAT AM I DOING WRONG? OR IS THERE A DIFF FORMULA I CAN USE?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!