Get instant live Excel expert help with LOOKUP Function

“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

Hello, I have a list of value from highest to lowest with different names next to the values. When i do a vlookup of duplicate values i get the same name. Is it possible to lookup duplicate values and if a name already exists in the worksheet it goes to the next name in the report?
Solved by X. C. in 28 mins
In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00.
Solved by E. Y. in 27 mins
need to find values in sheet1 for columns D, E F from sheet2. There are no unique values. Need to lookup using column B and column C from sheet1 and match with sheet2.
Solved by S. B. in 28 mins
How to create a name lookup for the spreadsheet. On my worksheet column g has the first name and Column h has there last name. How can I reference it to my main sick report worksheet in column A
Solved by O. J. in 29 mins
I have 3 columns. I have a set of lookup values and then 2 sets of data. The 2 columns of data are linked to each other, I need to check the data to the lookup value and then return a caller ID (example attached of expected result)
Solved by E. E. in 29 mins
VLookup reporting n/a when trying to match a date/time in an array. It works some times and not others. Relevant cells are i1063:l1067. AI1063:AI1067 confirm that the value of the lookup value is the same as the value in the array but still get random n/a's. There is no pasted data in the sheet and I have tested the most common n/a errors. Index/Match displays same problem.
Solved by K. S. in 22 mins
In the loading sheet, The calendar sheet is used as a reference to start the calculations in the "count down" sheet My formula lookup up a reference values and then adds the corresponding "countdown sheet" values. Row 3 works perfect because it in in the match is found in the first column, column. Row 4 finds its match in the second column, because of indexing I loose I set of data, the total row values should add up the values in column "B" Rows 4,5,6 etc each loose an additional column can u please help
Solved by K. S. in 24 mins
In the Shop loading sheet, I lookup the calendar sheet and where it finds a match ( Q???? numbers) , I want the formals to lookup the count down sheet and match the respective hours, but I only want the. when the formula finds a match. When it finds a match I want it to always start in the first match column and thereafter index.
Solved by Z. F. in 12 mins
I am trying to use Index and Match to return the first date something was billed. Conversely, eventually I need to find the same for the last date. Right now, I am using a simple index match based on the row number, but if the activity changes, I need to validate the activity on Sheet 1 with the description on Sheet 2. There needs to be some logic in the formula to match the description to ensure it is looking up the correct row. Thus the logic would be, lookup/match the description in column A, then lookup and return the corresponding date for the first column within the corresponding row with a dollar value in it.
Solved by M. A. in 29 mins
I have 2 columns one with product and the other with values $dollars values attached to the product, some of the products occur multiple times in the columns. I want to get excel to add all the values attached to a particular product. How do I do this? I used Sum(Lookup.....) but it just picks the first value, it doesnt sum all values.
Solved by K. L. in 18 mins