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

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

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