Please don’t judge but I have to use this formula ( I had to cut it shorter though as stackoverflow didn’t allow me to post mostly code), however it gives the “N/A” No match error message.
And the formula bar is underlined, so I was wondering if there’s a mistake in the syntax?
`=IFS(
'Backlog-2'!E5=111111112,"Potential Energy",
'Backlog-2'!E5=111111121,"Mechanical Strength",
'Backlog-2'!E5=111121112,"Mass and Velocity ➕ Potential Energy",
'Backlog-2'!E5=111121121,"Mass and Velocity ➕ Mechanical Strength",
'Backlog-2'!E5=111121122,"Mass and Velocity ➕ Mechanical Strength ➕ Potential Energy",
'Backlog-2'!E5=111122211,"Mass and Velocity ➕ Acceleration and Deceleration",
'Backlog-2'!E5=111122212,"Mass and Velocity ➕ Acceleration and Deceleration ➕ Potential Energy",
'Backlog-2'!E5=111122221,"Mass and Velocity ➕ Acceleration and Deceleration ➕ Mechanical Strength",
'Backlog-2'!E5=121221122,"Relative Location ➕ Mass and Stability ➕ Mass and Velocity ➕ Mechanical Strength ➕ Potential Energy")`
Can you please see what’s wrong?
New contributor
Shaimaa Sarwar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1