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

Hi i am trying to add a formula on excel that will include 3 fields. the 3 fields will include a colleagues name, a won/lost and a numbered value. i need the formula to search for x name, won or lost under x name and calculate the total value in the 3rd field. can you help with this formula

Hello! I'm trying to make a excel file that looks like the "interface" worksheet in the "sample". It would allow you to input an keyword and would search all other excel files in the same folder for the keyword. The format of other excel files approximately looks like the "target file format" in the "sample". And the file would generate a new excel file that would look like the "output file format". Which has the data of the column that contains the keyword and its data's corresponding time stamp.

I would like a formula to search for an ID number on other sheets and pull back information from the correct rows.

Hello, in the attached spreadsheet, I will be pasting data from a separate source in the "Sheet 2" tab. I need to have the student numbers on "Sheet 2" pull the corresponding student name (first and last), room (column I), Grade Level (column W) and Course (column F) found on "Sheet 1". The results of this search can be displayed on either Sheet 2 or a new sheet (Sheet 3). Also, Sheet 1 has multiple rows associated with a single name. I will need to pull the class connected to "01-01" in Column L (PRDS). I attempted to use the VLOOKUP feature but continued to receive errors. Please help!

This is my second attempt to resolve this issue I am having. My last attempt was abruptly cut short with no notification or resolution. Credits were used but no resolution, guidance or suggestions. Hello, in the attached spreadsheet, I will be pasting data from a separate source in the "Sheet 2" tab. I need to have the student numbers on "Sheet 2" pull the corresponding student name (first and last), room (column I), Grade Level (column W) and Course (column F) found on "Sheet 1". The results of this search can be displayed on either Sheet 2 or a new sheet (Sheet 3). Also, Sheet 1 has multiple rows associated with a single name. I will need to pull the class connected to "01-01" in Column L (PRDS). I attempted to use the VLOOKUP feature but continued to receive errors. Please help!

i have a userform called "frmupdatecase" which is opened by clicking on the button "update case" in sheet!invoices - main. when you select a name from the cbo box say "bridet" it displays the text in the fields. you can then edit this text and when the cmd button "update case details" is pressed the data is written to the cells in the sheet invoices main and the form automatically close. this is all great, however the next time you click on the button to open the form it has the last name already selected. i need it to be clear ready for the next name search and edit. if you open and close the form after a change it is clear which is really strange.

i need help with user forms. I have a worksheet that has forms. if you got to sheet - "bccs invoice" you will see a selction box at the top "rnginvocie" described by child surname. when you select a child surname the sheet auto updates with the correct data. if you scroll down you will see update buttons to update the text automatically, when i click on each update button a user form appears. what i am trying to do is have the user form auto populated with the relevant text depending on the child surname selected at the top of the sheet. so basically i dont want the combo box where you have to search for the child name everytime in the user form. then when you click on update cmd button it changes the data.

I need help understanding the following formula so i can use it. =IFERROR(INDEX(Sheet1!$A$2:$A$18,SMALL(IF(ISNUMBER(SEARCH($A$1,Sheet1!$A$2:$A$18)),ROW(Sheet1!$A$2:$A$18)-ROW(Sheet1!$A$2)+1),COLUMNS($N1:N1))),"")

I am starting a new workbook that is a searchbox to find and pull data off of multiple workbooks in SVN. 1) How do I refer in excel VBA to the data in the various SVN excel workbooks? 2) Do I need to pull all the data into a new worksheet within the new worksheet or am I able to search the data from the source and only pull the required data based off my searchbox input?

I have several page layouts (columns) and field names (rows) on a sheet, and I'm trying to build a matrix/ table that will identify which fields are a part of each page by marking it with a number 1 (for counting). On a separate sheet I have several "page layouts" pasted with each of the fields contained. I was thinking that some sort of formula could be built on the matrix page that would automatically determine whether a field was part of a page layout by using a combination of functions such as "if page layout name (above) is found in other sheet (search top row) and field name (left) is in the column (or adjacent column) of the matching column from the search, enter a 1 in the cell, otherwise leave blank).