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

I want to lookup on a list and report if the cell is empty insert 'Required' if the lookup cell has data insert 'Complete'

Solved by O. J. in 13 mins

How to lookup data and return relevant cell value with it's format( hyperlinks, colours, comments,etc.)

Solved by F. F. in 26 mins

I have a spreadsheet I'm working on where I need to lookup the values in multiple cells, and depending on those values, either return a "Yes" or "No". I know what the values should be to return a "Yes" or "No", but the problem is those values could (due to the nature of how this data was collected) be spread out 4 over different cells within each row.
I also have one data value that I would like to always return as a "No" value, again, depending on whether it appears in one of the four cells to be searched for each row.

Solved by V. W. in 13 mins

lookup equation where i do not know the look up value

Solved by S. H. in 30 mins

Is there a way to display only a shortchanged description of the total information entered into a cell? For example, entered into a cell is the description of an item "10 in. Left Tilt Contractor Table Saw with 52 in. Right Hand Rip Capacity and Cast Iron Wings." Instead of that mass of information as a product description can the cell be modified to display something simple like "10 in. Table saw?" It would be useful if the full amount of data entered into the cell would still be available for data lookup rather than be narrowed into just the data of 10 in. table saw.

Solved by G. C. in 11 mins

I am doing a vlookup, but the lookup value is references more than 1 time on my sheet, which references a different amount on the column index, I need to total sum of the multiple column indexs recalled by the multiple lookupvalue entered.

Solved by D. C. in 30 mins

Hi
I'm looking to fill in the rows 70 to 75 which requires a lookup of values below it and picking out the closest in time.
Example
In this race we have a time set for a 4:00 PM Start in cell B1.
With cell B70 it needs to grab the value that matches 30 minutes out from the values below it in A81 to B120. This value is the last value before 3:30PM which would be in this case $3.20 at 11:14AM
Cell B71 = 3.20 (lookup next to 11:14AM) last 15 minutes
Cell B72 = 3.60 (lookup next to 3:53:53PM) last 5 minutes
Cell B73 = 3.80 (lookup next to 3:56:12PM) last 2 minutes
Cell B74 = 3.80 (the very last listed price)

Solved by C. D. in 21 mins

Hello, I'm trying to lookup data within a date range. It's kind of like a VLOOKUP and kind of like a COUNTIF but I can't get either to work in this scenario. Can anyone help? I can provide an example.

Solved by Z. Q. in 13 mins

I have 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 A. A. in 19 mins

I need to use wildcard in both lookup array and in lookup value, is there a way to achieve that?

Solved by X. Q. in 25 mins