Hi Guys

I got very big table on excel, which i dont have enough time to fill it manual
So, please help me out, if you know the solution.

Here is problem...I have couple tables on the same Sheet, like in attached file.
I have one table filled with all prices and how to auto fill second table prices according to above table.

E.g. When I want to add 'type' of 'printer', it will look for (here i mean, there should be range of cells, not in order) same 'type' from above table and will automatic fill the price of the same type to the price column.

On screenshot case, it has to find "A3" type from above table and fill with the same price.

Thanks in advance
Untitled.jpg