Index Formula help

Options

Hi All,

I was hoping for some feedback on this index formula I am working on. I have mapped other sheets before but this time I am getting some push back.

So I took a screenshot of the sheet. The first issue I notice is that when I try to use [Account Number]2 it errors out. This same formula works using [Account Number]@row but it does not work in the cell it needs to Center Name.

=INDEX({KO request Range 3}, MATCH([Account Number]@row, {KO request Range 5}, 0))


I am not sure what I am doing wrong. Any help would be greatly appreciated.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!