Hi Buffiness,

You can use VLOOKUP functions in columns D:G to pull the relevant data.

For example, in D6 you could use:
=VLOOKUP(C6,'Cinema Costs Sheet'$A$5:$E$10,2,0)
This would check the Cinema Costs Sheet, column A, for the value in C6 and return the second column's value (the 2 determines which column you want returned).

So in E6, you would use:
=VLOOKUP(C6,'Cinema Costs Sheet'$A$5:$E$10,3,0)