Need Help

[RR_PAGAN0763]

Hello,

I'm having  a hard time combining find/search functions in my formula. Not sure if this is even possible? 

I am trying to extract data from my data sheet onto the cover sheet. Here is what I need: If column D has the following Text "_F", I need the status shown in Column F and the text in column N. 

To break it down further, if column D has "_F", I want to see in the next cell the contents of column F and in the cell besides that the contents in column N. 

[#2]

@RR_PAGAN0763 

How would you like the results?

Joined in one cell:

=IF(ISNUMBER(SEARCH("_F",D2)),TEXTJOIN(", ",,F2,N2),"")

Spilled in two cells:

=IF(ISNUMBER(SEARCH("_F",D2)),IF({1,0},F2,N2),"")