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

I've got 2 columns that have that I need excel to search for any duplicates within the said columns and I need it to return the same unique identifier for each duplicate. Whether it's found in column A or B

I have a table of data that i need to extract information from. I need to be able to search for an opponent (OPPONENT) and extract a list of all of the Levels (LEVEL) and sports (SPORT) they play along with the School (SCHOOL) they play against. I have my file

The Revenue and Revenue Subtotal worksheets contains information for a diagnostic laboratory. It tracks the doctor’s ID, the doctor’s name, the location number where patients go to have their testing done, and the monthly revenue received from each location. The Locations worksheet contains the address information for each location number. Search the Internet to find a diagnostic laboratory that is located in your city. Find five different locations around your city for this laboratory. On the Locations worksheet, fill in the missing address information.

I need a formula that compares one column (C:C) with another list (G2-G24) and if true pulls from a different column (E:E that relates to C:C if true). eg. search C:C for G2. Cx is G2. Show Dx.

on the sheet TEST in cell A277 I need a formula to search the sheet RMS CROWN OUTSTANDING. To match the area number from cell A3 and then to bring back the site name

I need to find the take data in E coloumn and search if it is in C coloumn and if i find it i shuould print Y in F coloumn. How can i do this with vlook up

Hi, I have several (around 41) excel files. I need to search between all files and display the search result. This has to be a live link since, there might be changes in the data. Also, the headers of each Excel file is different so I need a way of presenting the headers and corresponding data to that header. What do you think?

I want to do a data search. As long as there is one "day" in the data under the in charge and location. It will displays a "yes"

I need to extract names & numbers (D1:D60 , E1:E60 , G1:G60 , H1:H60) that have a specific word in L1:L60. My search word will never change.

i want to try to extract data from one excel document to another. one sheet is answers from a survey so they are in no order etc and the other sheet is alphabetically ordered. How can i do this without having to search through the excel sheet.