1

I have a spreadsheet that gathers data from a Google Form. In this form, we ask the users to choose between the different seating plans.

This is an example of the data gathered in the Response sheet:

        column A               
row 1 | Workshop
row 2 | Conference
row 3 | Story time
row 4 | Conference
row 5 | Workshop

In column B of the Response sheet, I want the image of the plan to appear depending on the data from column A. For example, the Workshop seating plan would be "Plan A" and the Conference seating plan would be "Plan B" and so on. I have the name of the plans and the images of the plans in another sheet called "Validation".

The sheet Validation is like this:

         Column A     Column B           
row 1 | Workshop   |   Plan A
row 2 | Conference |   Plan B
row 3 | Story time |   Plan C

Is there a formula that would allow me to accomplish this? Or maybe a script?

EDIT: Here is an example sheet of what I want to accomplish:

Response sheet should look like this:Result wanted

Validation sheet should look like this: Validation sheet

Here is a link of a test sheet (without a working formula): https://docs.google.com/spreadsheets/d/1QM9m0ue0Isgw1m1a3ww470GF_5Pvxd3P5n-pNdJFOKY/edit?usp=sharing

  • 1
    Welcome. Please do share a test form and spreadsheet as well as your efforts. Also, as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well -. (Why vote?) – marikamitsos Sep 3 at 16:15
0

There is no need a script. Try the next formula

=ARRAYFORMULA(IFERROR(VLOOKUP(A:A,Validation!A:B,2,),""))

enter image description here

  • Hello ! Thank you for your answer, unfortunatly when I try it in my sheet it returns an error. Here is an example spreadsheet I made with your formula: docs.google.com/spreadsheets/d/… – fab_pfds Sep 3 at 21:27
  • I also edited my original comment for more clarity and made a test spreadsheet. – fab_pfds Sep 3 at 21:39
  • I don't know if it's because my sheet is in French, but the formula worked after I changed the , to ;. Thank you for your answer and the help! – fab_pfds Sep 4 at 0:29
0

Try using the following (similar to @contributorpw) formula.

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A222,Validation!A1:B,2,)," "))

The essential difference is using a closed end column for column A

vlookup closed end column

  • I don't know if it's because my sheet is in French, but the formula worked after I changed the , to ;. Thank you for your answer and the help! – fab_pfds Sep 4 at 0:29
  • So, did you finally use open end columns (A:A) and worked?? – marikamitsos Sep 4 at 1:35
  • 1
    Both solutions worked for me! – fab_pfds Sep 4 at 17:45

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.