Get instant live Excel expert help to learn how to use Search function in Excel?

Not sure what this called to properly search so I am struggling. I import reports into Excel and get A1 with a name and A2 is blank. Then the following cells come in 2 rows that belong to the name at A1. If I want to sort by name, A2 is blank so I can't keep all of row 1 & 2 info together. Is there a way to say if A2 is blank, copy info from A1? I have 160 pages of this data so I can't just copy and paste individually.

On the sheet the named "Cycle Time", I need a formula in cell L3 that will search for the person's name in cell A3 in column P on the sheet named "Xactanalysis Raw Data" and return the earliest date in column Z of the "Xactanalysis Raw Data" sheet for that person's name back to cell L3 of "Cycle Time". I intend to copy this formula down the sheet.

What Formula would you need to use to search for a keyword in column 3 and use that word in a different column on the same row?

I am using excel to highlight duplicates and order research papers for a systematic review. My initial search had roughly 300 papers. I have done a new search which includes 400 or so papers. (each paper has various columns, such as Title, authors, abstract) etc. In theory my new search should include all 300 papers from the initial search (which I have already assessed). I match these old ("already assessed") papers to the new ones to (a) highlight new papers I must assess and (b) ensure that I am not missing any papers

i want to type something in A1. this will be the name of either a file or a folder. Then i want to press a button and have it generate hyperlinks to the location of the folder containing what i typed in A1. I only want it to search one main folder with multiple subfolders within it. so for example, in A1, i type, 12345. I then press the button, it searches through the main folder and sub folders, and then creates the hyperlink to only the locations of a folder named 12345 or a folder containing a file named 12345.pdf

This formula is working in 2 cells, but when I copy to a third cell it returns #N/A =IF(SEARCH("ALFA",C22),'QUOTE ENTRY'!$J$13,IF(SEARCH("ECKO",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$J$29,IF(SEARCH("DELTA-1",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$J$45,IF(SEARCH("DELTA-2",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$J$61,IF(SEARCH("V-STICK-S 300mm",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$I$7))))))

I need it so when I enter a part number in column "D" it will search the 'Parts List' sheet for the part number, and add the information such as "units, description, CNC, warehouse, and boat on the same line the part number was entered on the 'P.O's' sheet. I am short on time so need this done quickly. Thanks!

need help with vlookup formula , having more than two conditions to search and get the value from another sheet.

Column B has member introducer list and column F has member list, result require in column J to U as given in excel sheet. - From Column F need to search member ID in Column B how many times member ID has been used the data in same row in column F need to bring output in Row as given.. hop i tried to explain

I need help trying to figure out a formula to manipulate my data. There HAS to be an easy formula for what im looking for but I can't even figure out how to search for it, but I can explain it to someone - easily.