Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |