I have three columns with information filled in already. The value in Column C is dependent on two identifiers from Columns A & B (i.e., George is always the seller of Apples in America, but Sarah is the seller of Beets).
I have enough data in rows 1-8 that I want the cells from 9 onwards to start automatically filling the required information each time I input a new row.
Thus, if I enter in "Beets" in A9 and "Australia" in B9, then C9 should pull the value "Amy". I will pull this value down to autofill the rest of the table for future rows to be added automatically filling.
I used the INDIRECT(ROW-1) function to reference the whole column above the cell with the formula to get the correct data, if that makes sense...
A B C 1 Product Country Contact 2 Apple Australia John 3 Apple America George 4 Beets Australia Amy 5 Beets America Sarah 6 Carrot Australia Greg 7 Carrot America Belinda 8 Apple Australia John 9 Beets Australia _Formula:_ =INDEX((INDIRECT("C2:C"&ROW()-1)),MATCH(A10,IF((INDIRECT("B2:B"&ROW()-1))=B10,(INDIRECT("A2:A"&ROW()-1)))),0)