Iferror(vlookup) not pulling all data from a cell.

Options

I am using the Iferror(vlookup) function to track my teams inspections. Recently, I changed the form to have multiple locations, and since then the iferror(vlookup) is not pulling every locations date from the data set. Picture 1 is an example that pulls the data properly, picture 2 does not pull the data, and picture 3 shows the data set it is pulling from. I have tried switching the match type to false and still no change. I copy pasted the values in the data set sheet to ensure spelling is accurate as well.


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!