Excel - If/Then from another sheet

[SOliphant416]

How can I put data into another sheet if 1 column equals another? For example I have Sheet1 I am trying to copy to Sheet3 in column K or P if Sheet1 column equals "unknown" or "known".  It also should be in order of 1st "unknown" 2nd "unknown" 1st "known" 3rd "unknown". I can reorganize Sheet3 if necessary but Sheet1 is set and cannot be fiddled with. Please let me know if I need  to clarify as it has been a bit confusing to others when I was asking. 

[#2]

@SOliphant416 

Can you provide screenshots with some examples, or a sample workbook without sensitive data?

If you cannot attach them here, upload them to for example Onedrive, share them and post a link.

[#3]

@HansVogelaar Sample would be replaced by the FRxxxxLBxxxx number

[#4]

@SOliphant416 

Thanks for the screenshots. I'm afraid I do not understand yet what you want. Can you explain as clearly as you can?

[#5]

For example I would like to have the same information from Sheet1 cell C15, which is the first "unknown" denoted in Sheet1 Column B transposed into the 3rd Sheet "Sample Template Organization" in cell K10 the first "unknown" in that sheet

[#6]

@SOliphant416 

Sorry, I don't get it. Perhaps someone else understands...

[#7]

No worries, until I can figure it out I will be manually inputting them. Thank you for trying. 😄