hello all,

I have a basic question. In a doc I want to extract a value from a table based on a specific criteria.

Table 1

column A

Column B

Column C

column A where column C= “X”

I am trying with filters but I did not succeed to retrieve only the column A. the filter gives me the full row and if I am adding a .columnA at the end it gives me all values and not the filtered ones.

I found a work around by spliting. I am doing a formula to filter and then I am calling the formula.columnA but I wonder if I can do it once

thanks for your help

Alex