“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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