Someone out there must be an Excel espert. I need help with formulas (complicated ones). Basically I have one spreadsheet with two worksheets in it. I want to look up data in one worksheet (10 columns) determine if a dollar value in one of the columns is over a certain threshold, and then copy the row to the second worksheet. VLookup?
I'm really stuck, and am on a tight deadline.
You can email me at work firstname.lastname@example.org