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 need a formula to lookup a certain cell value in a table and display the data in the cell at the top of the column it is in. (my hlookup isn't working)
Solved by T. B. in 11 mins
Hello, I am using a Hlookup table but I need the text it returns to be a clickable hyperlink. I have attached the example. Thank you!!
Solved by Z. H. in 22 mins
hlookup shows error #ref! - not sure what is wrong. excel version 2016
Solved by E. B. in 25 mins
I am attempting to create a form within excel where when a program/name is selected from a drop down list (developed from a larger table containing several lines of information for each program/name), cells to the right (in the same row) are automatically populated with information from the table for the specific program/name selected. The idea is to duplicate this so that two programs (out of the table of several) can be compared one to one. I've started a HLOOKUP formula, however it does not appear to be outputting the information
Solved by S. Q. in 17 mins
How do I create a formula where there are 5 value range, eg. 1-5=1, 6 -10=2, 11-15=3, 16 - 20 = 4, 21 - 25 = 5. What I am trying to do is whenever a number in a range is select, it automatically selects either 1,2,3,4 or. Is it the HLOOKUP function
Solved by Z. H. in 30 mins
I need a way to only use HLOOKUP when certain conditions are met
Solved by C. F. in 29 mins
I have multiple sheets. One summary sheet that will display information pulled from a specific sheet, which I will indicate using 2 drop downs. One drop down is the date, which I will use for an hlookup, and the other drop down is the specific tab name. In the table array portion of the hlookup formula, I want the sheet name to change with the drop down. All sheets I refer to with the hlookup formula have the same layout. So the only thing that needs to change is the sheet name within the hlookup formula. I've tried INDIRECT, OFFSET, but I cannot figure it out.
Solved by M. L. in 21 mins
Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range E5:N8). Be sure to use appropriate relative and absolute cell references. Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row.
Solved by X. C. in 23 mins
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). 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 base salary is tiered based on the number of years of service, find an approximate match. Fill the formula into the range E3:E31, if necessary.
Solved by G. W. in 22 mins
im trying to do hlookup formula but keep getting error saying theres a problem with this formula but I know there isn't
Solved by Z. B. in 12 mins