Forum Discussion
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 shoul...
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.
HansVogelaar Sample would be replaced by the FRxxxxLBxxxx number
Thanks for the screenshots. I'm afraid I do not understand yet what you want. Can you explain as clearly as you can?
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
