Using 'Indirect' on a result from filter

[dicken]

Hi,
I have used filter to bring back one text name from a range =

     LET( fv, FILTER(Sheet1!$G$5:$G$10,Sheet1!$H$5:$H$10="Y"),fv)

I would like to feed this into 'Indirect' , but it does not seem to work? if I refer to the cell which the above is in this does.
so ;

=LET( fv, FILTER(Sheet1!$G$5:$G$10,Sheet1!$H$5:$H$10="Y"),INDIRECT(fv))

Does not work

but

NDIRECT(B3)  ,

does, where the Filter is in B3,

is there a way around this?

Richard.

 

[JEC]

Can you post sample data? Maybe you don't need indirect

 

[dicken]

Can you post sample data? Maybe you don't need indirect

 

[dicken]

I did not know I could attach a document? how do I do this,
also, not sure why I would not need indirect? for example ; I want to return the names range , the column of 2's,
names "AA".