if formula

Hi, I need to search for a match between a range of text and strings of data in a table. If a match is found then I wish to return that match into the next column. I have tried this formula =IF(ISNUMBER(SEARCH(Schools,[@Tags])),Schools,"") but it will only return data for cells on the same...

Hi, I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve; Car Type B14:B23 Tax Treatment E14:E23 Private % F14:F23 Input Data B28:B37 I would like the Input Data B28:B37 to be pre-populated depending on what the Tax...

Hi there, I have 3x Form Check Boxes. If any of them are ticked, I would like sheet "Dairy" to be visible. If none of them are ticked, sheet "Dairy" should be hidden. I have linked the 3x check box references to cells P1, P2 and P3. In P4 I have the following formula...

hi, so the workbook is set up like this, with 4 columns: Column A - country code Column B - country name for that code and then you have the same, but not in the same order Column C - country code Column D - country name i need a formula looks at the country code in C2. If C2 is present in...

Hello, I am at a loss as to what is happening here. I have some survey data on one sheet, and I am putting together a summary on another sheet. I want mean, standard deviation of the sample, and median for some of the data. I am compiling the summary statistics both for all surveys and for...

Hi All, Good morning/afternoon/evening depending on where you are in the world. I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and...

Hi there, I would like cell D310 to return blank, if cell B310 is blank. Both contain an if formula.. Cell B310 =IF(SUM(F310:G310)<>0,433,"") Cell D310 =IF(N(B310)<>"",FYE_Date,"") In this instance, both cells should be blank but cell D310 is returning the FYE Date. Does anyone have any...

Hi there, I have a basic formula =IF(D181=B268,B181,) This correctly returns "Dairy Foods" However, when I try to extend the range =IF(D181:D182=B268,B181:B182,) It returns #VALUE !, instead of "Dairy Foods". Does anyone know why it's going that? Thank you!

<tbody> A B C D E 1 Job Number Date Amount Week 1 Week 2 2 02/03/2019 09/03/2019 3 08/03/2019 15/03/2019 4 201 05/03/2019 3182.20 5 201 05/03/2019 2137.80 6 201 07/03/2019 4349.80 7 201 08/03/2019 2362.80 8 201 11/03/2019...

Hi, I am trying to determine if I am using the correct type of formula and figure out why I am getting an error with the formula I am using (maybe I should use a different formula completely.. such as an index or some sort of array or a if... IDK). I need to search column C row 1:556, on...

I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore...

Ok two I have two files File 1 Column A Column B Currency FX Rate USD 1.14 EUR 1 JPY 126.77 File 2 Column F Column G Column K Local Currency Local...

Hi there, i was hoping someone could help me with this query. i have a large set of address data which needs to be cleansed and analysed to find duplication within rows. i have included a sample set of data which hopefully will portray my issues. Hopefully, someone can help. <tbody> Name...

Hello all - I am trying to figure out a way to do the following please, and could use some help: I have the following headers: A1 = TestA, B1= TestA Verified, C1= TestB, D1 = TestB Verified, E1= Time, F1= Time Verified, and finally G1 = All Tests Satisfied, I have a lookup that populates the...

Hello! I am trying to use a DATEDIF formula to calculate a number that is then used to in an IF formula to generate a score. The issues is that for some of the DATEDIF calculations the EndDate is before the StartDate. When this happens, I have the formula generate a "0". I then use the...

Hello, I need help with a complex (to me) IF statement. Here is the link to the sheet I am working on: https://docs.google.com/spreadsheets/d/1RbJJknpUzxzi4eGcju7nD0N_X9wfb69uCpunZQxayC4/edit?usp=sharing What I need is on Friday Poles A13 - I need a formula to check Friday Poles D13:F13...

Hello, I am trying to change the values in my Status column to either Overdue, On Track, or Blank. These will reference my Due Date column. I have figured out how to have my cell = Overdue or On Track, but am having difficulty adding an additional layer to the formula. Currently, I have...

I have this very very big list of almost 700K rows and about 30 columns of data. I have a somewhat working formula to do what I want but it doesn't really work 100% of the time. The data is of all purchases done during a set period and I have a formula that determines what type of purchase it...

Good morning all, i am looking for some assistance if at all possible. I have a spreadsheet with a list of dates (all Mondays) that represent weeks within a large work planner I am developing. I am looking for an IF formula that will let me know if “today()” is within a certain week i.e. if...

Hi All, Below is the data: I am trying formula, but giving error...