Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup & Vlookup
I am trying to use both hlookup and vlookup in one cell
This is my formula =IF(ISERROR(HLOOKUP(U2,'Employee Absence Schedule'!$A$3:$AG$13,5,FALSE)),0,(HLOOKUP(U2,'Emp loyee Absence Schedule'!$A$3:$AG$13,5,FALSE)))&" "&IF(ISERROR(VLOOKUP($B$28,'Employee Absence Schedule'!$A$4:$AG$13,2,FALSE)),0,(VLOOKUP($B$28,' Employee Absence Schedule'!$A$4:$AG$13,2,FALSE))) I am first looking up the date with the Hlookup Then the Employee name with the Vlookup |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup & Vlookup
Looks nice. What is your question/problem?
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "TWP" wrote: I am trying to use both hlookup and vlookup in one cell This is my formula =IF(ISERROR(HLOOKUP(U2,'Employee Absence Schedule'!$A$3:$AG$13,5,FALSE)),0,(HLOOKUP(U2,'Emp loyee Absence Schedule'!$A$3:$AG$13,5,FALSE)))&" "&IF(ISERROR(VLOOKUP($B$28,'Employee Absence Schedule'!$A$4:$AG$13,2,FALSE)),0,(VLOOKUP($B$28,' Employee Absence Schedule'!$A$4:$AG$13,2,FALSE))) I am first looking up the date with the Hlookup Then the Employee name with the Vlookup |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup & Vlookup
I want to look up both a date and employee name and have it return only one
answer. With my current formula it is giving me the answer twice. How do I use Hlookup and Vlookup in the same formula. "Luke M" wrote: Looks nice. What is your question/problem? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "TWP" wrote: I am trying to use both hlookup and vlookup in one cell This is my formula =IF(ISERROR(HLOOKUP(U2,'Employee Absence Schedule'!$A$3:$AG$13,5,FALSE)),0,(HLOOKUP(U2,'Emp loyee Absence Schedule'!$A$3:$AG$13,5,FALSE)))&" "&IF(ISERROR(VLOOKUP($B$28,'Employee Absence Schedule'!$A$4:$AG$13,2,FALSE)),0,(VLOOKUP($B$28,' Employee Absence Schedule'!$A$4:$AG$13,2,FALSE))) I am first looking up the date with the Hlookup Then the Employee name with the Vlookup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup or Hlookup | Excel Discussion (Misc queries) | |||
VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
USING VLOOKUP AND HLOOKUP | Excel Discussion (Misc queries) | |||
vlookup and hlookup | Excel Worksheet Functions | |||
can i use vlookup and hlookup together | Excel Discussion (Misc queries) |