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

Column Q: MSKU – String representing a product Goal: Count number of days a row item in column Q was out of stock between 7/1/17 and 7/31/17 and pull that number into the row corresponding with that item in Column S Reference Array: The table Columns D:L represents a report in which each row a daily snapshot is given of a SKU in column F, the warehouse code representing the warehouse in which it is in stock in Column H, the quantity within that warehouse in Column I, and the date from which the data was pulled in Column L. Problem: Because my items may be in stock in multiple warehouses on any given date, it is challenging to create a formula to count the number of different dates in which an item had stock in any warehouse, as one SKU may appear multiple times in the column corresponding to the same date. The reports used to create the table Column D:L do not show line items without stock – They only have information on products that had stock on the dates recorded. So I cannot use a lookup formula to find dates in which stock was zero, because those dates would not be listed in the column. It will be a challenge but what I am looking for is a formula is column S that, using the line item in column R, will search the Table (Columns D:L) and find the number of dates between 7/1/17 and 7/31/17 in which no data could be found for the the line item in Column R
Solved by K. J. in 18 mins
I have an Excel Spreadsheet I have created by converting 2x PDF Files across. What I want to create is a way to have a dropdown menu to lookup specific data from sheet2 relating to that row, and auto fill the spaces in Sheet 1.
Solved by T. S. in 25 mins
I have a table of life insurance rates. Along the "x axis" is benefit amount, and along the "y axis" is age. For example, if I am 18 years of age and elect $10,000 of coverage my rate is $1.00. My lookup formula is one column off and I cannot figure out how to fix it. Any ideas or better ways to handle this type of formula?
Solved by M. J. in 15 mins
I have the following formula =IF(G5>20,0,LOOKUP(G5,'0-1 pump'!A4:A22,'0-1 pump'!L4:L22)) I would like to replace '0-1 pump'!A4:A22 and 0-1 pump'!L4:L22 to automatically link with an indirect function to these columns but in different worksheets depending on a list of worksheet names in a cell.
Solved by C. L. in 15 mins
I have the formula below and I'm trying to replace the '0-1 pump'!A4:A22 and '0-1 pump'!L4:L22 with indirect links to worksheets dependent on a list of worksheet names in a cell =IF(G5>20,0,LOOKUP(G5,'0-1 pump'!A4:A22,'0-1 pump'!L4:L22))
Solved by G. A. in 11 mins
How do I lookup and match approximate dates from 2 tables of unequal size?
Solved by V. C. in 19 mins
i have dates across the top and i have numbers in the cells. i want to lookup the date that matches today and return the value in the cell. If that value matches a 1 then I want to display "OUT", if it doesnt match I want it to show "IN"
Solved by D. B. in 26 mins
i am trying to make my formula return a zero if the lookup cells are blank =IF(SUM(O4:W4)="","","iferror(VLOOKUP(Y3,$D4:$K4,7,FALSE),""")
Solved by T. D. in 29 mins
I'm working on an assignment, been on this for 4 hours and just can't get the concept. In cell F4, enter a Lookup function to display the interest rate of the loan. The function should reference the borrower’s credit rating and the table array inrange A15:C18. Include the range_lookup argument to ensure an exact match.
Solved by T. H. in 11 mins
Hello, can you please help me with the formula in "Project Health" tab. I need the formula in column P "Forecast OOM" to reflect a lookup against column V + W + X + Y + Z + AA, and return the total value associated to the code from tab "Data NWA and Budget OOMs'. At present, it is only looking up column “V” and returning that value only from Data NWA and Budget OOMs, wondering if it can look up and add multiple codes.
Solved by B. B. in 13 mins