Formula for : two values to find in another sheet this words and copy the hole cell

Not sure what you mean but here is a start.
Try this in B3:

Formula:

Please Login or Register  to view this content.

and fill down.

A3 is not possible to find, there is an extra word in the middle (FAI).

Would you manually add all the results you expect to see.

This would no doubt be simplified if you were to accept a helper column in the Data sheet so that the descriptions could be truncated and aligned with those in column A on the Data sheet.

Like the other helpers in this thread, I'm not completely sure what results should be returned, but I went with the following formula in B3, which should be array-entered (confirmed with Ctrl + Shift + Enter instead of Enter):

=IFERROR(INDEX(Data!$B$2:$B$17,IFERROR(SMALL(IF((ISNUMBER(SEARCH(TRIM(MID($A3,1,FIND("-",$A3)-1)),Data!$B$2:$B$17)))*(ISNUMBER(SEARCH(TRIM(MID($A3,FIND("-",$A3)+1,100)),Data!$B$2:$B$17)))*(ISNUMBER(SEARCH(B$1,Data!$B$2:$B$17))),ROW(Data!$B$2:$B$17)-ROW(Data!$B$2)+1),1),SMALL(IF((ISNUMBER(SEARCH(TRIM($A3),Data!$B$2:$B$17)))*(ISNUMBER(SEARCH(B$1,Data!$B$2:$B$17))),ROW(Data!$B$2:$B$17)-ROW(Data!$B$2)+1),1))),"No Match")

The formula can be filled right for your "status 33" column and filled down for the other rows. The formula looks for the first match that contains the text on each side of the hyphen and the text at the top of the column (e.g. "FAI"). This will work around the issue spotted by Jacc in post #3, but only if the text on either side of the hyphen in column A is unbroken when it appears in your list on 'Data'. If there is no hyphen in column A, it just looks for a text match. Take a look at the attachment to see if the formula is returning results as desired:

Glad to help, good luck!