Get instant live Excel expert help with CONCATENATE Function

I need to find all values in Sheet 2: Column B that match the values in Sheet 1: Column C-X and return the values in Sheet 1: Column A to Sheet 2: Column E. There may be multiple matches and these need to be Comma Separated (or in separate columns and I can concatenate them afterwards) If some sample data is required please let me know.

hi i want to do the following if value is true on one work book file then one another workbook i want to concatenate all the information in the cells on the row before the true value to be copied over if employer says yes i want the employer information to go to another spreadsheet workbook which is interested employers

I need to incorporate data validation into the following formula: =IF(C2="Credit Contract Agreement Unsigned",INDEX($D$2:$D$934,MATCH(CONCATENATE(B2,"Credit Contract Agreement Signed"),$E$2:$E$934,0)),"") Column F has a date 14 days after the loaded date, and I need to ensure that whatever result date for a signed is pulled falls within those two dates.

I need help with a google sheets concatenate formula from columsn c, d and e whilst retrieving more information from another sheet

Hello and good morning, i entered a simple concatenate formula to fill down about a thousand rows.. and when i did so.. it only copied the end results of the first cell.. ??

I need to calculate the time and number of days until issues have been resolved. There is a formula for days but also need one for time. I found a formula found in cell N2, but it would require concatenate cells and would make report to complex for my audience.

I need to understand the formula =IF(ISBLANK($G27),"",HLOOKUP(TRIM($G27),INDIRECT(CONCATENATE(H$4,"!$B$11:$HH$31")),21,FALSE))

Hey! I'm trying to copy info from one sheet to another. I use the "T" and Concatenate formulas. Most of the time it works but sometimes on the new sheet it comes out blank. But when I click on the cell it shows the formula.

I am trying to concatenate 8 rows of data down 3398 columns. All I get is the formula in the cell.

Cheers! How will I show a blank cell even though it has a formula (concatenate)? What I want to happen is, it will only show up after the value takes place on a cell? Please assist. Thanks!