reporting_95
New Member
- Joined
- May 7, 2019
- Messages
- 30
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hello,
In my reports, I am using vlookup to fill blank rows and columns with data that comes from a different workbook. This works but its tidious to have to either type in the formula in each cell or use the Lookup & Reference option in each column. Please see the example below:
This the full data workbook:
And this is my report:
I use the client ID in vlookup to fill the columns in my report. The formula I use is =VLOOKUP(A2,[Book1]Sheet1!$A$2:$B$10,2,FALSE). Is there an easier, more efficient way to get the data in my report without having to use vlookup all the time?
Thanks!
In my reports, I am using vlookup to fill blank rows and columns with data that comes from a different workbook. This works but its tidious to have to either type in the formula in each cell or use the Lookup & Reference option in each column. Please see the example below:
This the full data workbook:
Client ID | Last Name | First Name | Item | Cost |
515155 | Smith | John | Book | $1.50 |
515156 | Doe | Jane | Box | $10.50 |
515158 | Hayes | Charles | Chair | $11.50 |
515158 | Rodriguez | Alex | Baseball | $5.00 |
515159 | Jeter | Derek | Glove | $30.00 |
515160 | Jordan | Michael | Sneakers | $150.00 |
515161 | Mertz | Ethel | Dress | $100.00 |
515162 | Draper | Don | Suit | $1,000.00 |
515163 | Walker | Karen | Purse | $500.00 |
Client ID | Year of Purchase | Sale Type | Last Name | First Name | Item | Cost |
515158 | 2020 | Final | Hayes | Charles | Chair | $11.50 |
515162 | 2020 | Final | Draper | Don | Suit | $1,000.00 |
515159 | 2020 | Final | Jeter | Derek | Glove | $30.00 |
515163 | 2020 | Final | Walker | Karen | Purse | $500.00 |
515156 | 2020 | Final | Doe | Jane | Box | $10.50 |
515161 | 2020 | Final | Mertz | Ethel | Dress | $100.00 |
515160 | 2020 | Final | Jordan | Michael | Sneakers | $150.00 |
515160 | 2020 | Final | Jordan | Michael | Sneakers | $150.00 |
I use the client ID in vlookup to fill the columns in my report. The formula I use is =VLOOKUP(A2,[Book1]Sheet1!$A$2:$B$10,2,FALSE). Is there an easier, more efficient way to get the data in my report without having to use vlookup all the time?
Thanks!