VLookup #No Match Error
I am looking for guidance for the utilization of the VLookup formula. I have formatted this formula within one of my Smartsheet sheets and I keep getting the #No Match error message, I have verified this information already:
1) Range to retrieve data from is 3 columns wide by about 1000 lines long, so I don't believe that I have hit the capacity
2) Confirmed with co-workers the set-up of my formula (=vlookup(the cell within my sheet that I need the data to reference, the additional sheet range to find the data, then the column # to retrieve the data from, "false")
3) Tested the formula with values that are in the underlying sheet and the information is present
Looking for any advice at the moment!
Help Article Resources
Check out the Formula Handbook template!