Forum Discussion
How to copy a rowdata when matching a value in a column to another worksheet
Hello, I am looking for help with an excelsheet I am putting together. I have data differences that are presented in column A of worksheet 1: Raw Material and Finished product. In the next couple...
Thanks for your reply. Okey I see how this works, but it does not work in another worksheet (after changing the values A2:A9 to worksheet!A2:a9) How can I incoperate this?
=IFERROR(INDEX(worksheet!A$2:A$9,SMALL(IF(worksheet!$A$2:$A$9="Raw material",ROW(worksheet!$A$2:$A$9)-1),ROW(worksheet!$A1))),"")This formula works in my file. I have to confirm the formula with ctrl+shift+enter because the attached file is version Excel 2013. Does it work when you open the attached file?
OliverScheurich Thanks for the reply. I tried it in your file and it worked. Then I tried the exact same in mine and it did not work fully. I attached part of the file i am using for it. In my case it should use the array of d4-d10. It also does not work in "blad 2"