index

the below is the formula that iv tried to make work if cell f1 is SA i need one formula if its OA i need another =IF(F1="OA",IFERROR(INDEX('SST1 SST2 AML 03.05.23.xlsx'!Table4[Emails sent],MATCH(TRUE,INDEX('SST1 SST2 AML 03.05.23.xlsx'!Table4[Prop Ref]=[@[Prop...

Not even sure where to start. The formula shown is supposed to read the various grades of material in P,Q,R,S column and then find which grade bin it sits in from the reference table and return the BIN type from Row 5. This used to work in an old version of the sheet I have but I'm trying to...

I am trying to figure out the formula where I need a cell to auto populate a result based on the input of another cell. For example. Column A (Region) will be the cell that will have the input. Column B (Destination Location) is the cell that I would like to auto populate based on the input...

hi all, i have this overview: And in my other sheet entitled "XXX" i have this table: I am using this formula to calculate my nominal value in EUR: =IF(J2="EUR";I2;I2*VLOOKUP(J2;'XXX'!AO6:AS7;MATCH(J2;'XXX'!AO6:AS6;0);FALSE)) it should in the case above say 12046,37 * 0,134192, since...

Hello, I have Similar problem. the first if formula before the OR is working greatly, however after or its not giving me the data which i need. basically, I have department names in a column, each department have two values separately. for example, if the first value is zero and the second...

I have a data table say A1:N100 Column A is Category Column B is Sub Category Columns C:N would be Jan - Dec I need a dynamic sum that only sums up if Category A value is "Criteria1", Category B value is "Criteria2" and for only the month of my choosing. Sometimes this will be current month...

Hi All, Sorry if that isn't very clear. What I have is a spreadsheet where I have a MAIN LOG, which I use to keep track of client appointment and report timescales. That all works fine, so don't worry too much about that. What I need help with is this. When 'Y' is entered in Column R (indicating...

Hi all, Hoping someone can help me with this query. I have a workbook I am working on that currently sums all the values in column "O" if the value on the same row in column "L" is "WP" or "BS" until an empty cell is reached. I would like to expand upon this formula so that it still sums like I...

Greetings experienced, With my limited knowledge of Excel, only know basics, I was thinking to use function "=IF(AND(N4=1,O3>0), , ) " & "(INDEX(O:O,ROW()-O3-1" ,in formula but do not know how to structure/complete it. When cell in Column N =1 and above row of it, cell in Column O >0 , assign...

Hi everyone, I'm hoping you can help me with an excel formula to solve a problem I'm stuck on. I think I am pretty close to solution but just can't crack what it is I need to make the formula work how I would like. Basically, the problem is this: My formula is pasted all down column B. I need to...

So i got this excel workbook that contains 2 sheets in sheet 1 column b - employee id column c - ranking on each equipment column d - employee name column e - date column f - worked hours for employees column g - shift (day shift or night shift) column h - equipment id in sheet 2 column a -...

I'm sure this will be easy for one of you. I'm close, need a final tweak. I have a table of kids names with batting order in column1 (B3:B16), Inning # in row1 (C2:H2) and position they are playing each inning (1B, 2B, SS, etc.) scattered throughout the table. I'd like to create a unique cell...

Hi there, I have found some old posts on this topic but nothing that seems to solve my issue. I am using the below formula in order to pull a list of individuals names that have correspondence through the same email address. For example if Mr John Smith, Mrs Jane Smith and Miss Janet Smith are...

G'day from Australia! Long time lurker, first time poster! Getting a bit stumped figuring a formula to generate a report using INDEX MATCH to detail all "VACANT" positions. This roster is an example (which generally varies in rows and titles) the only "fixed points" I can constantly refer to...

Hi, I am looking to create a calendar on the first tab of a workbook I have. Currently the workbook has multiple sheets of data, each sheet containing data related to a different type of work that is being scheduled in for different people. In order to currently find out what type of work...

hello everybody, I have a problem with excel if command and I need your help I have let's say the below columns distance calendar price 200km 12 months 10€ 400km 24 months 17€ 600km 36 months 29€ 700 km 48months 33€ the distance might be a random number between 200 and 700 I want to create...

Hello, I work for a company that has several employees clocking in and out electronically from home. All this information gets logged into our system which then generates an excel file with fields such as member name, date, task they are working, pay period, and clock in and clock out times...

INDEX.Nth returns (every) nth element(s) (starting at the desired position) from a one-dimensional array and provides output options and full control over data type(s) inclusion/exclusion (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all...

I have the following data in excel. I would like to derive the "Action" column for a "Person ID" based on the Y or N indicators in the "Value" column and what's in the "Month" column ABCD1Person IDValueMonthAction21N1/1/231st action32Y1/1/2341N2/1/232nd action52N2/1/231st...

Hi I need help filling out the highlighted colum. The goal here is to fill out in Sheet 1, Column C "Closest After Dates in B", with the closet date after column B "Date signed up" by vlooking up to sheet 2 column B "Time", with criteria that Type is either "email", "outbound" or "inbound". I am...