Creating cells dependent on a drop-down list

I'm looking to create a simple table of items. We'll tall this Table A. The cells in the first column of Table A are a list (using data validation) redtricted to the first column of another table, called Table B. Here's what I want to do: When I select an item from the list in Table A, I want the cells to the right of that cell in Table A to adopt the values corresponding to that selection in Table B. In a sense, I'm looking to make a database in Table B of say 1000 rows/entrys, and to be able to call upon those values by selecting them from a dropdown list.

I've already tried the IF() command, but it is laborious, and limits me to 7 entries.

I've attached the file if that helps with some sample entries. It will make it more clear what I'm trying to describe.
Calc template.xlsx

Here's a picture for ease:
upload.PNG

Thank-you!

Thank-you jefferybrown!