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

I need some help with search formula excel please.

Hi - I need a formula that can look at a Member Number (Column A) and report back if location (Column B) matches 1 of 6 locations, then looks to the date of occurance (Column N) but only adds back 1 value of repeating dates. I have this, but it is not coming back with the right answer... =SUMPRODUCT(('2017'!I$3:I$10000=$A223)*ISNUMBER(SEARCH({"2","6","58","69","76","97"},'2017'!N$3:N$10000))) Information is corporate private, so I won't be uploading file.

I have a value in target.formula on sheet that I want to search column k for on sheet2, then output today's date to the matching row in column P of sheet2

I have a fuels calibration table previously done in Excel. The process is to dip a long ruler into the top of the tank, hit the bottom and pull it out. The level of the fuel is then read from the spreadsheet. The current spreadsheet is broken into 1/8" increments and I must now break it down further into 1/16" increments. I am aware that Excel is not friendly to feet and inches and I have a work around. The problem is when I try to take the number of gallons from the previous sheet and populate my new sheet. The numbers go into the cells fine and I even have a formula to take the average between the two. The problem, is that with the previous worksheet in 1/8's and the new one in 1/16's I cannot figure out how to make the cells search for their data relatively on the smaller spread sheet. Any ideas?

C5 contains 1625MPGW, F5 contains quantity. Need to search for MPGW and have quantity insert into column H5.

Hi I am producing an invoice register. Data is to be entered in a weekly format of either 4 or 5 weeks The staffs hours are spread over multiple contracts so that data is separated as each contract has its own invoice the invoice is to include a break down of time that has been spent on it and by who I am trying to make the breakdowns automated. I am trying to find or create a formula that will search for a persons name on a specific tab, then total the amount of hours for all jobs under that contract and return that value I have tried =SUMIF(DATA1!P6:BM6,'TO 01-05'!B92:C92,DATA1!P12:BM12) pt1 - the staff names pt2 - the staff name it needs to match pt 3 - the field of data underneath it that it should total from It returns a blank cell despite data entered =SUMPRODUCT((DATA1!P6:BM6='TO 01-05'!B92:C92)+0,DATA1!P12:BM12) pt1 - the staff names pt2 - the staff name it needs to match pt 3 - the field of data underneath it that it should total from It returns N/A you help would be appreciated

I have two spread sheets one was an export with part numbers and prices, the other spread sheet has part numbers and current prices . I need a formula to work Finding corresponding part numbers and then replacing old prices with new pricing. Both list do not look the same, not all part numbers are on each sheet, I only want to update the prices for the corresponding part numbers on sheet on. I need like a “If/find replace formula”. I can get it to work on one line but then when I change up the order so it has to search I cannot get the formula to work Thank you

I'm having a problem with VLOOKUP to search for data on a spreadsheet by an order number

I am using two different excel sheets that contain checks that have been cashed and a list of all checks run. I was trying to use a VLOOKUP to search for the check # cashed from the total check list and to add in the date it was cashed- please help

I need to add to this formula =AVERAGEIFS('AC07 Data'!N:N,'AC07 Data'!B:B,B4) to also search for tab "Notes" cell D4