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

I have a complex lookup formula but don't know why it isn't working now.
Solved by T. C. in 25 mins
Need to lookup data from one shet on the other
Solved by I. F. in 25 mins
VBA Macros 1) insert x (cell-defined) blank rows, copying data from above row down (have managed this part), then jumping down to cell Ax-1 (where the data left off), and repeating the process: inserting x blank rows, and copying data from above row. 2) insert multiple values that correspond to a lookup item down one column, repeating if a condition is met
Solved by I. L. in 12 mins
This request has already been started. Please would the same person kindly continue to work on it. Thank you. here are my two problems, both involving a VBA macro that I need to repeat until the end of the data: 1) insert x (cell-defined) blank rows, copying data from above row down (have managed this part), then jumping down to cell Ax-1 (where the data left off), and repeating the process: inserting x blank rows, and copying data from above row. 2) insert multiple values that correspond to a lookup item down one column, repeating if a condition is met
Solved by X. H. in 28 mins
Looking for help with Complex lookup / pattern matching formula and similar.
Solved by V. F. in 25 mins
1) insert x-1 (cell-defined) blank rows, copying data from above row down, then jumping down to cell Ax-1 (where the data left off), and repeating the process: inserting x blank rows, and copying data from above row. 2) insert multiple values that correspond to a lookup item down one column, repeating if a condition is met
Solved by B. D. in 18 mins
Hello, I am attempting to use an Index lookup to list specific returned results based on a single order number, I also want to exclude results with non alphanumeric values. I have my Index function working correctly, and I have a separate lookup verifying if the source values are numeric or alphanumeric. Can you help me combine them.
Solved by O. J. in 14 mins
problem: Need lookup formula to pull multiple tracking numbers from another sheet using 2 criteria. column A: critieria 1 column B: criteria 2 column C: # Quantity Column D: desired tracking numbers (Multiple if possible, if column C has 2, there would be 2 tracking numbers) if not possible: column E: next tracking number
Solved by I. U. in 13 mins
I am trying to use a lookup function to pull values only if they meet the criteria
Solved by T. B. in 21 mins
I need to lookup a data from a column by referring another column in the same sheet. The reference cell is in another cell. I know vlookup would help but the table array does not have the exact value of the cell which I used to refer.
Solved by M. Q. in 15 mins