- Expense Code::=INDEX('MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$F$2:$F$9000,MATCH(0,COUNTIF($A$1:A1,'MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$F$2:$F$9000), 0))::formula
- Shipping::=SUMIF('MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$F:$F,$A<<rowNumber>>,'MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$C:$C)::formula
In the 2nd example we are getting the sum from said sheet in column c where A<rowNumber> matches column F in said sheet. Again wanting to reference the current contents in cell A<rowNumber> to search the other sheet and not a specifc cell
Any insight as to why this isn't working or how this might work would be appreciated.