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...
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
Sorry, I don't get it. Perhaps someone else understands...
- No worries, until I can figure it out I will be manually inputting them. Thank you for trying. 😄