# Get instant live Excel expert help with VLOOKUP functions

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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