Using the match function to look up a value while also following a separate criteria

[drewbear]

I have a data set that I am trying pull from in order to create a visual representation/chart of available open spots in a grid system. Among the variables in the data set are a 'moving' and a 'code' column for the spots in the grid (i.e. 3Left9, representing a spot in the grid). If the code number is present in the data set, then I want the visual chart to come back as 'full' in that respective location and if the value isn't present then I want the value to come back as 'empty'. I did this part through with the match function using =IFERROR(IF(MATCH("3Left9",'Tray Locations'!$F:$F,0),"Full"),"Empty"). But I also want to add the condition of only having values whose 'moving' row is listed as 'no' coming back 'full' in the chart. I tried a few things but got a spill error. Any help would be appreciated. I attached an example sheet

[oeldere]

Please explain more.

in the data sheet you expect the result?

2left1 (is table 2 left, first cell)?

[drewbear]

Please explain more.

in the data sheet you expect the result?

2left1 (is table 2 left, first cell)?

Sorry if that was a confusing expalaintion. there are 4 separate grids which is denoted by the first number, each grid is then broken up into left or right, and then each side has 33 availble spots. So something like 2right23, represents the 23rd spot on the right half of grid 2. I would like the grid on the first sheet i posted to populate with either 'full' or 'empty' depending on if that #side# code appears in the data set, but only if it also appears with a 'no' in the corresponding 'moving' column