and & or statement

I need help with creating 2 formulas for the sheet pictured (I typed the info that I want momentarily, however, I need a formula to generate it in the future). First, I need a formula that will look at G26 & K26 and place text in U30 based on the value in G26 & K26. I know what I want to do...

=INDEX(A:A,MATCH("9-"&U29,F:F)) I want the above formula to return a value from column "A" by matching "9-number" from F column. For example, U29 cell = 135. So 9-135 would be in F:F column and it would give me the data in A column. Please help. Thanks!

Hi all, I am hoping someone can help with what I think should be a pretty easy formula, I am trying to return a value of “medium” or “high” based on if W11 is blank & P11>5 for three different criteria in N11 “average”, “poor” or “good”. I don’t understand why I am struggling with this so...

I have a dataset with 500+ athletes, each with information on age category, best distance, season in which PR was achieved, and the absolute time of the PR. On another tab ("SBT") I have the overall season best time per age category on 6 distance over 5 seasons (total of 150 season best times)...

I have a field of data which needs to be compared in multiple places, I keep almost getting there but am missing the final bit to make it work, would appreciate any assistance with this! One table of data has an individually coded number which needs to be searched for in the other table of...

Hi all, I'm having issues with the below-nested loop. (error getting this formula uses more levels of nesting) this is matching like below e.g: if the F4 value between 48 and 61 then 4000 need to print =IF(AND(F4>=48,F4<61),4000, IF(AND(F4>=61,F4<76),5000, IF(AND(F4>=76,F4<91),6000...

Hi all, I've nested an if and/or formula and all seems to be working well except for one odd result. I was wondering if someone could help. Attached is a screenshot. The formula reads as follows for row 3...

Hello - I am looking to create a formula that will return 'YES' or 'NO' based on different factors.... Without going into detail on the other parts of the formula unless necessary, the entire formula works until I added the bolded section below...

I ran into a speed bump yesterday and today with a true or false statement from data in a single column containing a speed (see attached picture). Most, if not all, speeds are two digits in length; however, yesterday and today I had several speeds post in single-digit format (i.e., 3, 6, 8...

I have a worksheet containing cells G3:G100 that needs text and fill formatting via a “Conditional Formatting” rule that looks at the corresponding cell in the “H” column to see if the text contains any one of the letters B, D, F, H, J, L, N, P, or R. The actual contents in H3:H100 are any one...

hi I am trying to get a particular result, but I have obviously got the syntax slightly wrong in my formula and I wonder if someone might look at it and indicate where I went wrong. Here is the formula:- =IF(AND(Q2="L",P2<=2.2,OR(Q2="P",P2<=2.2)),95,IF(AND(Q2="W",P2<=2.2),-100*P2+100,0)) In...

Hi aLL, Have the following formula which works fine, however want to add to it so that it looks for not just the text "A1" but also "B1", how can i amend the below formula? =IF(RIGHT(TRIM(D2),2)="A1","YES","NO") Thanks,

Hi all Is there a way to construct an AND & OR sumproduct lookup that uses Tickboxes alongside a criteria range and also a toogle to state which of the list should be used as an OR or an AND criteria to adjust the outcome...

Hello All - Thanks so much for any ideas you might have on this: I am trying to combine the following statements, each of which seem to work fine on its own, into one statement. Have googled, have searched here - surely I am missing something fundamental. Many thanks for suggestions...

Hi, I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written: =OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No")) Basically I want the format to highlight when a...

Hello everyone, I am having trouble with counting instances where a specific value appears within a subgroup of a group. An example of the data are below: <tbody> GROUP ID DATA 1 1 Main St 1 1 1st St 1 2 Main St 1 2 2 1 Main St 2 1 Main St 2 1 2 2 1st St 2 2 </tbody>...

I'm trying to nest multiple IF statements, along with IF(AND(OR) statements within one cell. The "Premium Table" I have to use is below, along with a sample of the the worksheet. The question is: What IF statement do I enter in cell D2 to obtain the correct premium? Premium Table Age Range -...

Hello, I'm trying to forecast values along down a table. I have already used Forecast (Linear) formula without a problem, but now I need several conditions to be met. This is what I have so far: {FORECAST.LINEAR([@Date];AND(IF([Date]>=([@[Date]]-5); [Score];"");IF([Date]<[@[Date]]...

Here are my code: Sub GL()With Application .EnableEvents = False .ScreenUpdating = False End With Dim i As Integer For i = 2 To 20000 If Trim(ThisWorkbook.Sheets("FRA&FFC").Cells(i, 6).Text) <> "" Then If...