Quotient of 2 values which reside in different columns of different tables

[gvanlut]

This is my first time posting something here, hoping to get some help with my worksheet.

I've tried several different formuals and combinations, however keeps resulting in errors.

Here's what I want:
If the header from a table matches the value of column A in a specific table then the value in column E of the same table needs to be divided by the following:
if a value from column M matches a value from column A in the corresponding table then the value in column E of the same table

Have tried the following formulas:
- =IF(Table25[Patio roof beams]=M5;IF(Table1[Delivery beds]=N4;Table1[Volume]/Table25[Volume]
This one returns with #VALUE !

- =QUOTIENT(IF(Table1[Delivery beds]=P4;Table1[Volume];IF(Table25[Patio roof beams]=M5;Table25[Volume])
This one returns with #N/A

Would greatly appreciate any help.

 

[Oscar Cronquist]

Did you enter the following formula as an array formula?

=IF(Table25[Patio roof beams]=M5;IF(Table1[Delivery beds]=N4;Table1[Volume]/Table25[Volume]

Your formula returns an array and if the first value in the array is blank your cell becomes blank as well.

Table1[Volume] must have the same number of rows as Table25 otherwise your formula returns #VALUE.