I have one worksheet that has various columns, one of them being a drop down field where you can pick Quoting;Ordered;Dropped;On-hold;Lost.
In the next worksheet I would like to grab all the jobs that have a Quoting status. I have tried a VLOOKUP but, it is only grabbing the word "Quoting" and not the rest of the information in that row. Is there a way to grab the entire row using a lookup for the word Quoting.
I hope someone can help. I am not sure if I explained this very well.

Thank you!!!!!

Jen