Hello!
My initial gripe comes from wanting to copy only certain cells from a row into another sheet. I've read a bunch of the threads for create a helper sheet, add dummy columns, and then use VLOOKUP, but I just cannot get it to work for myself and I'm uncertain what I'm missing!
I have Sheet A that contains all my raw data. Sheet A has an automation when "Fail" is entered in Column "Pass/Fail," it copies an entire row onto Sheet B. Then I have Sheet C, which I want to use the VLOOKUP formula to find data from several columns of Sheet B.
For context, each "Fail" is tied to a failure # and Sheet C's purpose is to investigate that failure, so that's why I want to copy so much information (Part #, Vendor Name, Failure Date) to Sheet C to prevent transcription errors.
At this moment I went back to the starting blocks and have removed the dummy columns. Can someone please help educate me which sheets the dummy columns should go on and how I can use the VLOOKUP formula for this scenario?
Thanks so much!