Dependable drop down lists- multiple rows.

Hi guys,

Since I just joined, hi to everyone, hope you are all good.

I'm making this excel file, I have columns called "Bay", "Cell" and "Product", instead of typing in data manually, I want to have a drop down list.
So starting from [Bay], I have a drop down list with following components: 40, 41, 44, 45, 46, CO Building.
The next column is [Cell], and depending on what was chosen in [Bay], the specific selection shows in [Cell].
For example if [Bay 40] is chosen the selection in [Cell] is: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ,11, 12 ,13 ,14 ,15 ,16 ,M1 ,M2 ,n/a.
Then, if [Bay] is changed, selection changes accordingly- hope that's clear.
This is achieved with:
"Define Name" in Formulas,
A drop down list created in "Data Validation" with a List that points to a defined name,
Another drop down List that points to =INDIRECT($C$2)

Hope I'm clear so far, so this all works fine for me, I have a drop down list and depending on what's chosen in it, a correct selection shows in the next cell.
Now, there could be 50 or more entries a day in the log, I got this working fine in one row, because "=INDIRECT($C$2) points it to where I want, but I want to extend function of that column all the way down to the bottom of the sheet.
So, is there another way of pointing it, maybe to the cell directly on the left? I tried =INDIRECT("RC[-1]",0), but it doesn't work...

I'm going to attach my Excel file, so hopefully you can understand what I'm trying to describe here.

Thanks!
Matt

PS. OK I'm not able to attach the file for some reason, so here it is on my Google Drive.

Edit: Never mind, the file go attached in the end, must be just me