| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Hi there, I am trying to create a formula to search through a bunch of data
and I can't seem to figure it out. Here is what my file looks like (this file cannot be edited or sorted as it is used by other programs) There is not column heading/names. A B C D E date name hours OT hours vacation hours The file is quite big. I want to use a vlookup to find a certain persons hours on a certain day. So if I type a name into Cell AA and the date in Cell AB, I would like to have their hours in Cell AC, OT hours in Cell AD and vac. Hours in Cell AE. I've looked at a few other posts but I cant figure out how to add 2 vlookups in the same function. Any help would be awesome |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
One way
=sumproduct(($a$2:$a$222=ab1)*($b$2:$b$222=aa1)*c$ 2:c$222) -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf's Fan" <Leaf's wrote in message ... Hi there, I am trying to create a formula to search through a bunch of data and I can't seem to figure it out. Here is what my file looks like (this file cannot be edited or sorted as it is used by other programs) There is not column heading/names. A B C D E date name hours OT hours vacation hours The file is quite big. I want to use a vlookup to find a certain persons hours on a certain day. So if I type a name into Cell AA and the date in Cell AB, I would like to have their hours in Cell AC, OT hours in Cell AD and vac. Hours in Cell AE. I've looked at a few other posts but I cant figure out how to add 2 vlookups in the same function. Any help would be awesome |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Send me a workbook with these msg snippets and exactly what you want. You gave no example -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf''s Fan" wrote in message ... Thanks for the speedy reply. But I can't seem to get that formula to work. Does it multiply all thier hours? I just want to get the hours for that specific day. So if I enter the Name Matt in cell AA and the date (uh.. 5/7/07) in cell AB, then in cell AC it would say his hours and in AD it would be his OT hours. "Don Guillett" wrote: One way =sumproduct(($a$2:$a$222=ab1)*($b$2:$b$222=aa1)*c$ 2:c$222) -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf's Fan" <Leaf's wrote in message ... Hi there, I am trying to create a formula to search through a bunch of data and I can't seem to figure it out. Here is what my file looks like (this file cannot be edited or sorted as it is used by other programs) There is not column heading/names. A B C D E date name hours OT hours vacation hours The file is quite big. I want to use a vlookup to find a certain persons hours on a certain day. So if I type a name into Cell AA and the date in Cell AB, I would like to have their hours in Cell AC, OT hours in Cell AD and vac. Hours in Cell AE. I've looked at a few other posts but I cant figure out how to add 2 vlookups in the same function. Any help would be awesome |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Sorry.. I did figure it out. I wasnt paying attention to my typing. (I forgot
to turn it into an array) Thanks for your help "Don Guillett" wrote: Send me a workbook with these msg snippets and exactly what you want. You gave no example -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf''s Fan" wrote in message ... Thanks for the speedy reply. But I can't seem to get that formula to work. Does it multiply all thier hours? I just want to get the hours for that specific day. So if I enter the Name Matt in cell AA and the date (uh.. 5/7/07) in cell AB, then in cell AC it would say his hours and in AD it would be his OT hours. "Don Guillett" wrote: One way =sumproduct(($a$2:$a$222=ab1)*($b$2:$b$222=aa1)*c$ 2:c$222) -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf's Fan" <Leaf's wrote in message ... Hi there, I am trying to create a formula to search through a bunch of data and I can't seem to figure it out. Here is what my file looks like (this file cannot be edited or sorted as it is used by other programs) There is not column heading/names. A B C D E date name hours OT hours vacation hours The file is quite big. I want to use a vlookup to find a certain persons hours on a certain day. So if I type a name into Cell AA and the date in Cell AB, I would like to have their hours in Cell AC, OT hours in Cell AD and vac. Hours in Cell AE. I've looked at a few other posts but I cant figure out how to add 2 vlookups in the same function. Any help would be awesome |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Huh? The formula I sent did NOT need to be ARRAY entered.....
-- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf''s Fan" wrote in message ... Sorry.. I did figure it out. I wasnt paying attention to my typing. (I forgot to turn it into an array) Thanks for your help "Don Guillett" wrote: Send me a workbook with these msg snippets and exactly what you want. You gave no example -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf''s Fan" wrote in message ... Thanks for the speedy reply. But I can't seem to get that formula to work. Does it multiply all thier hours? I just want to get the hours for that specific day. So if I enter the Name Matt in cell AA and the date (uh.. 5/7/07) in cell AB, then in cell AC it would say his hours and in AD it would be his OT hours. "Don Guillett" wrote: One way =sumproduct(($a$2:$a$222=ab1)*($b$2:$b$222=aa1)*c$ 2:c$222) -- Don Guillett Microsoft MVP Excel SalesAid Software "Leaf's Fan" <Leaf's wrote in message ... Hi there, I am trying to create a formula to search through a bunch of data and I can't seem to figure it out. Here is what my file looks like (this file cannot be edited or sorted as it is used by other programs) There is not column heading/names. A B C D E date name hours OT hours vacation hours The file is quite big. I want to use a vlookup to find a certain persons hours on a certain day. So if I type a name into Cell AA and the date in Cell AB, I would like to have their hours in Cell AC, OT hours in Cell AD and vac. Hours in Cell AE. I've looked at a few other posts but I cant figure out how to add 2 vlookups in the same function. Any help would be awesome |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
