Hi veejar,

I get a ref error on my Master table so now results are being displayed.

Basically the Master sheet table needs to display the values from the lookup sheet based on the entries in the entry cells. Also, the user will not always select all of them and they need to be unique values which is why your drop downs wouldn't work.

Sorry, it was probably due to a lack of explanation from my part.

Thank you.