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?
Cheers,
Martin K.