“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by Z. H. in 11 mins

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

Solved by S. S. in 14 mins

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

Solved by I. F. in 29 mins

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

Solved by V. J. in 17 mins

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

Solved by S. L. in 13 mins

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)

Solved by D. L. in 17 mins

"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."

Solved by C. H. in 29 mins

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

Solved by E. Q. in 16 mins

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?

Solved by S. S. in 23 mins

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

Solved by M. B. in 14 mins