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