Step 1a: I’ll copy the values from column A in all 3 sheets into a new workbook.Step 1: I want a consolidated list of products. I want a quick look at how much revenue I made, by product, over all 3 days. In this example, I have sales reports from 3 separate days. We were chatting about it and I realized the vlookup would solve her problem. Last week a co-worker needed to compare values on a report from two different dates. And I keeping finding more and more ways and reasons to use it. I recently discovered the value of vlookup in excel.
