Need to find relevant row/data based on the list of values

[anuwers]

Dear Forum Members.

In Sheet1 - I have values in excel in columns A,B,C,D,E,F,G,H as my main data.
In Sheet2 - I will have the values listed in column A and column B

Macro required to find as follows:
I need the result in Sheet3 for those values of Column A, to pull out from Sheet 1 and place it in sheet 3 as C,D,E,F,G,H,I,J. If not able to pick from Sheet 1, then say "not available" in column K , to understand there is no record in Sheet 1

Column B of sheet 2 to be available as it is and it should get display in sheet3 as like sheet 2

Note: I have given excel for easy understanding. Please note that Sheet2 coluumn A values will be available as single word or mixed with more than one word. But it will be there in either of the rows.


Thanks
Mohamed Anwar