If a cell is equal to one of the elements of a list then get data from another cell

Question

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:

Validation sheet should look like this:

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

Answer 1

There is no need a script. Try the next formula

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

Answer 2

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