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