Forum Discussion

SOliphant416's avatar
SOliphant416
Copper Contributor
Mar 21, 2024

Excel - If/Then from another sheet

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. 

  • 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.

Resources