Cross Reference from Form's Response sheet



I am currently working with 2 sheets - 1st sheet is the response from form where I'll be getting my data while 2nd sheet is where I want the details to be auto populated.

However, when new response is submitted to the 1st sheet (thru the form), it shows #NOMATCH to the 2nd sheet.

It seems that I have to update range of the vlookup formula every time there us a new a response from the 1st sheet.

Is there a workaround for it to be constant reference like adding a $ in google sheets?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!