Hi All,

Awesome community, hoping someone can help.

Basically what I'm trying to do is have a formula in column E of the below autopopulate as soon as information is entered in the columns preceding it (Columns A, B, C, D)

I cannot have the formula in that column UNTIL there is information in the adjacent columns, as that throws off something else I'm doing. So if columns A, B, C, and D are blank, column E should be too.
Currently column E's formula is a simple Vlookup using a 2nd sheet in excel (google sheets)...the formula is below:


=VLOOKUP(D3,Sheet2!$A$1:$B$3,2,0)

The Vlookup is pulling an individual's name (the provider) based on the state that is entered in column D. The table I am using is in sheet 2

The reason why column E needs to remain blank is because I have a trigger that is sending an auto email as soon as a "new row" is entered in my document. So I can't just prepopulate column E with my formula all the way down the column and "wait" for the adjacent columns to be filled in, because even if they are then filled in, no auto email trigger will take place (because excel "thinks" that isn't a new row as it already contained data in column E).

Hope that makes sense. Little screenshot below:
excelforum.PNG

Sheet 2 where the info is for the Vlookup:
excelforum2.PNG

Any idea if this is possible... if you need more info from me, I'm happy to provide. Thanks everyone!