index

  1. R

    vlookup, INDEX, or SUMPRODUCT???

    This hopefully comes through okay. I am looking to automate the information going into columns G and H. I highlighted the date ranges to make this a bit clearer. In the real world I will have "Source 2" with samples every 10 minutes. "Source 1" is just whenever a fault occurs. The goal is...
  2. C

    Index/Match | Index/Small Formula

    Hello experts, I am looking for assistance with my formula. I am using an index/small formula in the following scenario: I am pasting raw data into Tab A, which includes status (example: Active, Inactive), and additional rows of data. In Tab B, is a summary table, that pulls rows of data from...
  3. D

    Search 2 columns, for MATCH in column in a second sheet, insert value

    Hi, I have 2 sheets, I want to search / match Sheet2 cols A or B with the value in Sheet3 col. C, if there's a match I also need both col A & B in Sheet2 to be numeric (neither cell blank), if these criteria are met then Sheet3 col D = "BZ" else blank. What's the best way to do this? Any help...
  4. B

    Find column by header AND filter by another column?

    I'm working on a table that references another and returns the number of employees in each of several regions, by year. The source table includes a row for each employee, with a value of '1' in the column for each year they worked: Destination Table: Year Region Employees 2020 a 1 2020 b...
  5. S

    Count across a data set or index

    Hi, I need a count formula that counts names across multiple columns. I need to know how many people attended Philadephia. The answer is 5. Then pull the formal down to know how many attended Orlando = 6. please note the blank cells are blank b/c there is a formula iferror return "" A1 first...
  6. skyh3ck

    1st match column header, 2nd lookup a value in same column, 3rd return corresponding value from the very first column ?? need help

    Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...
  7. S

    Please help me with my workbook as Iam novice to Excel.

    Please help me with my workbook as Iam novice to Excel. I have 2 sheets, "STOCKS" and "ORDERLIST" .....I want to automate in Allocation Column the email address of the client matching the criteria of Product_Name,Size and Gender. its should return the email address as unique value, is drop down...
  8. k3yn0t3

    INDIRECT with INDEX(MATCH())?

    Hi there. Can anyone help me with an indirect with nested index match formula that's dynamic enough to allow me to get values from other sheets which change depending on the Factory and Metric I need them for? My hope is to have one formula that's dynamic to copy it across and down as the file...
  9. F

    How to show relative value in searched values?

    Hi all, I want to search within range A1:B16 the CODE for each NUM in D1 to D8 with one condition. There are some CODEs that are of the form XXXXZZ and XXXX24 that belongs to the same "group". The CODE that ends with 2 numbers is the "MAIN" CODE within than group. The "MAIN" CODES begins...
  10. B

    Index Match with zeros and duplicate data.

    Hey all, Thanks for taking the time to review my question. I must be missing something simple but for whatever reason I am missing something. In "Tab A" I have a list of "A" names, "B" dates and "C" total hours, In "Tab B" I have "A9:A39" each date of the selected month, "A1" the name I want to...
  11. T

    Combining Index, small, if, row

    Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...
  12. D

    Which box for which parts?

    Hi everyone hopefully you can help me out with this as my head if fried. I have had a look at some of the other answers for similar questions but I can't see how they would work for my problem. I have a long list of parts in my inventory. I also have a list of boxes for storing the parts. I...
  13. Y

    Data Matching

    I havr data in Column AD that has the same date in column AC but no on the same rows. Column L is connected to column AC and AD but the corresponding rows has different names. I want to display the Name on Column L that is connected to column AD and display it on the row where Column AC has a...
  14. 9

    Index Match function to derive the entire list in a table based on a selected variable/s.

    Hi Everyone, I'm working on this unique case. I've a table (raw data) in which I have Column 4 columns named Country, Supplier, Parts, and Net Price. Country Supplier Parts Net Price Germany Intel Part 1 2.30 Germany Intel Part 2 2.34 Germany Spirax Part 1.A 2.38 Germany Romoss Part...
  15. C

    Stock inventory - count unique sequences from barcode

    Hi, I am looking to obtain an overall itemised count from a delivery taken from the scanned barcodes. The first image is the full inventory catalogue at where the items are looked up against. ABCDEFGH1ItemPart numberTests Per Kit ( tests x cartridge )2Amylase reagent4T8520640 (160x4)The full...
  16. T

    Using Excel to create a schedule table from given data table.

    Hi Everyone, This has been stumping me for about a week now and I need assistance. My work's scheduling program produces a horrible table to track schedules and I am trying to take the information it outputs and create a printable schedule from it. I have been able to do it for most of the...
  17. M

    Xlookup formula to return multiple results

    Hi. I have a list of unique IDs (column A) with different dates in column B, C and D. If one of the dates are 1 year old, or older, I want the ID and the age (today() - date in column B, C, D) to be presented in a list in Column I (ID) and Column J (age of date), up to a maximum of 10 results. I...
  18. N

    Problem populating table based off two criteria from a different table

    Due to security controls on my system, XL2BB is not an option. Sorry, I really would prefer using that to writing this all out. Below is the destination table (well, one of them) I'm using to capture employee hours per month per department. This department is "AC" and is one of the few that has...
  19. R

    2 different formulas depending on a cell value

    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...
  20. R

    Searching Grade Bins and Returning Product

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top