Get instant live Excel expert help with VLOOKUP functions

I'm using hlookup match with todays date, but in excel it show zero for future, I need to blank for future date

DESCRIPTION: =IF(C2="","",IF(ISBLANK(IF(C2="yes",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!$B$1:$AA$1000,2,FALSE),IF(C2="no",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!$B$1:$AA$1000,3,FALSE),""))),"NOT YET",IF(C2="yes",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!$B$1:$AA$1000,2,FALSE),IF(C2="no",HLOOKUP(VALUE(MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)),Sheet2!$B$1:$AA$1000,3,FALSE),""))))

Hi ExcelChat, can you explain how to do a reverse hlookup?

3. In cell E2, enter a formula using the HLOOKUP function to determine a staff member’s base salary (which is based on the number of years of service).

I have been given help creating a formula to calculate the cost of sale from a separate sheet. The formula calculates the latest COS every monday. I unable to understand how to change this formula to look on Sundays instead, could you please help =IFERROR(SUM(ARRAYFORMULA(HLOOKUP(TRANSPOSE(ARRAY_CONSTRAIN(FILTER(ARRAYFORMULA({TODAY();TODAY()-ROW($A$1:$A$23)}),ARRAYFORMULA(WEEKDAY({TODAY();TODAY()-ROW($A$1:$A$23)}))=2),1,1)),OFFSET('PPC KPIs'!$B$2,MATCH($A3,'PPC KPIs'!$A$2:$A,0)-1,0,4,500),3,FALSE)))/SUM(ARRAYFORMULA(HLOOKUP(TRANSPOSE(ARRAY_CONSTRAIN(FILTER(ARRAYFORMULA({TODAY();TODAY()-ROW($A$1:$A$23)}),ARRAYFORMULA(WEEKDAY({TODAY();TODAY()-ROW($A$1:$A$23)}))=2),1,1)),OFFSET('PPC KPIs'!$B$2,MATCH($A3,'PPC KPIs'!$A$2:$A,0)-1,0,4,500),4,FALSE))))

create a formula that uses the HLOOKUP function to assign a group code (A, B, C, D, or E) from the FurnitureGroups range in the Rental Information worksheet to the furniture listed in column B I cant figure out what the proper table of array is ? =HLOOKUP(B2,?,2,FALSE)

"In cell E2, enter a formula using the HLOOKUP function and structured references to determine a staff member's pay rate (which is based on the number of years of service). a. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members do not receive a raise after every year of service, find an approximate match. b. Fill the formula into the range E3:E31 if necessary."

having trouble with following a HLOOKUP formula example. It works sometimes, but if I change the data, it doesn't work

I'm working with Index Match & Hlookup on a value: 03/23/12 - 03/23/13. It's identical everywhere it needs to be but I'm getting a N/A error. When I edit it to 3/23/12 - 03/23/13 (remove the 1st zero it works. Why would this be? How do I avoid?

I need to understand the formula =IF(ISBLANK($G27),"",HLOOKUP(TRIM($G27),INDIRECT(CONCATENATE(H$4,"!$B$11:$HH$31")),21,FALSE))