I made a workbook that has all our business expenses. I want to make 3 small reports that report on 3 different categories (fuel, advertising, maintenance). How can I get this info into my smaller reports? I tried VLOOKUP, but it stops at the first result (I need each one). I thought maybe something where when I add each expense, it sends it to the report automatically? (Maybe like an autopopulate?)
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to search another workbook for multiple results
0
Answers
0
Try this "vlookup":
It's a youtube video that shows you how to do it.
The formula is not simple but is thoroughly explained in the video tutorial linked to.
=IFERROR(INDEX($B$2:$B$8, SMALL(IF($D$2=$A$2:$A$8, ROW($A$2:$A$8)-ROW($A$2)+1), ROW(1:1))),"")