Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The IF function will include an excel TEXT function and a nested IF function with a VLOOKUP function.
The logical test will verify if cell G2 is greater than 0.
The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2)
The value if false will return blank.
Solved by D. E. in 29 mins