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 |
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) |