VLOOKUP from Form Input

Hey guys,

I've been unable to find a solution for this one.

I have a sheet from which I "VLOOKUP" values from another sheet. This another sheet gets its values from a FORM input.

When I reference another sheet as a lookup_table, I select the whole sheet in which the FORM data input ends up, the new line is never included in it whenever a new line is generated from the FORM input.

How do I go about this? I do understand that I can't VLOOKUP a row that does not actually exist yet.  Is there a work around?


Martin K.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!