Excel - If/Then from another sheet

Question

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".&nbsp; 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&nbsp; to clarify as it has been a bit confusing to others when I was asking.&nbsp;

hansvogelaar · Answer

SOliphant416&nbsp;
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.

soliphant416 · Answer

HansVogelaar&nbsp;Sample would be replaced by the FRxxxxLBxxxx number

hansvogelaar · Answer

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

soliphant416 · Answer

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

hansvogelaar · Answer

SOliphant416&nbsp;
Sorry, I don't get it. Perhaps someone else understands...

Forum Discussion

Excel - If/Then from another sheet

Share

Resources