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!”
Here are some problems that our users have asked and received explanations on
I am trying to do a lookup for each item ID that will return the highest service level for each item ID out of multiple entries.
Solved by I. D. in 13 mins
What I want to do is lookup a value and if there is a number to go with the value then produce the number, but if there is no number then to produce a zero.
Solved by D. L. in 12 mins
Vlookup function to determine the commission rate. Lookup the SalesID for each order (from column F). Return the “Commission Rate” that for that SalesID to column I.
Solved by X. E. in 25 mins
Hi, I am looking for quick coaching on what I believe is the SUMPRODUCT formula, for doing a lookup that involves greater than or less than values in a target cell, to then return a specific value in a different cell.
For example. I am measuring the value in B2, and depending if it is less than, equal to, or greater than a value in cell in c2, return the corresponding value from a table L4:N9. Kind of like a vlookup but different.
Can you help with this? Should be quick and I am looking for assistance asap. Thank you!
Solved by M. J. in 11 mins
I am trying to lookup and update the quantity field in one spreadsheet from another spreadsheets data after matching the Sku and Size columns
Solved by Z. W. in 23 mins
I am trying to lookup and update the quantity field in one spreadsheet from another spreadsheets data... I was helped but I disconnected the session before down
Solved by G. S. in 22 mins
I am trying to return the second and third value found using v lookup and offset
Solved by Z. U. in 21 mins
I'm trying to combine two worksheets using V LOOKUP but keep getting error messages
Solved by E. E. in 17 mins
I am trying to create a lookup formula in excel. Where I have a table full of prices for various jobs to do on various phones at work. So for example If i had one cell say iphone 5, and another said screen, the result would be the price I am looking for, and would be able to change based on what the 2 cells say, different phones and different jobs.
Solved by V. W. in 28 mins
I am trying to pick item sales values from table, which has two references, one is year, other is product.
I am able to get sale value with V lookup for one reference (product), however I am struggling to get corresponding value of product for different years (Years are in column, products are in rows)
Solved by T. S. in 27 mins