VLookup
Your situation sounds similar to mine. See the question entitled "Two Level
Search" - about 7 "posts" below yours. I was able to use the advice prvided (by Skaria), and it works very well. "Mary Lou" wrote: I have a workbook with two worksheets. On the first - it has the following columns: Inv # Employee Fees Paid on the second worksheet i have the following: Inv # Employee Fees Billed Hrs Billed I want to be able to pull the information from the 2nd worksheet onto the first one. I know how to do vertical lookups but in this case, I need two. I need the system to first look for the invoice # and then look for the employee. Once it sees those two matches, i want it to populate the fees billed and hours billed. Is this possible? Thanks! |
All times are GMT +1. The time now is 12:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com