I am trying to restrict the values of some cells to a list.
The values are taken from a structured table with 2 columns
I tried using this formula
=OFFSET(INDEX(Table1[Column2],MATCH("f",Table1[Column1],0)),0,0,COUNTIF(Table1[Column1],"f"))
but I get the message: "The formula you typed contains an error"
If I use the same formula with SUM and evaluate it I get the correct range.
How can I determine the error that excel is warning me about? I can't use structured tables in List formula?
Bookmarks