I want to check the Form Response Data based on two criteria.

Here is the Form Response Data (on a Separate Tab): enter image description here

I want to fill the 3 Columns (on the Submissions Tab, image further down) with data from the Form Response tab when the Date matches in the Heading Date (Column B or example 13-Sep).

Column C (Form Response Tab) goes into "Submitted" (Column C, Submissions Tab) Column D (Form Response Tab) goes into "Date" (Column D, Submissions Tab).

This is so I can create Traffic Lights based on submitted data: Submit Data on or before the Date (13-Sep) = Green Submit Data after the date (13-Sep) = Yellow No Submission = Red

Here is the Submissions Tab structure.

enter image description here

All works fine when there is just the one weeks data. The formulas I am currently using are:

Submitted Column Row 4: =IFERROR(VLOOKUP(A4,'Form Responses'!$B$2:$D$8,2,FALSE),"No")

Date Column Row 4: =IFERROR(VLOOKUP(A4,'Form Responses'!$B$2:$D$8,3,FALSE),"No")

I will only ever have 3 months at a time in the Submissions Tab.

  • Welcome. It would be great help if you would share a link with a test sheet. – marikamitsos Sep 9 '19 at 21:56
  • 1
    What exactly is your problem? – Tedinoz Sep 11 '19 at 11:06
  • @woodieOS How are you progressing with your problem? Have you solved it, or are you still looking for help? – Tedinoz Sep 23 '19 at 0:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.