look up

  1. R

    Look Up Table Request for Help

    Hi, I have a set of data I want to compare to a table of set criteria but cant fathom out how to get a cell to bring back the right answer. Basically, we have criteria for "track categories" on types of rail and sleepers allowed, I then need to see if the types recorded meet the criteria set...
  2. J

    Sum of year to date

    Beginning of month 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 Net working days 21 20 23 21 22 22 21 23 22 21 22 22 This part data and I have a separate sheet where I am gathering data for each month...
  3. A

    2D Arrays match with Column

    I have a 2D-Array and I want to look up for values in the column. arrDestination(0, i) = Name(i) (asdfg, csda, asdfg,zzz) arrDestination(1, i) = Values(i) (100, 50, 100, 60) My 2D Arrays contains the names and values. If my arrDestination Array match with Column A then I want to insert the...
  4. G

    Look Up Functions - Variable Index Numbers

    Hi, I have a workbook that contains two sheets. Sheet 1. PONumbers Sheet 2. PORequest I am trying to find a way to look up a reference in Sheet 2 (Column A), find a match in Sheet 1 (Column A), then return the value of the last populated cell in the row. I have tried Vlookup, but as the...
  5. R

    Lookup Formula

    Hello, I am looking to see if there is a formula that will give me the values in column C below. What I am looking to do is if the Transaction ID is the same and there is no red step in column B then code all of column c as igo for that transaction ID. I used a vlookup but am potential going to...
  6. W

    Lookup not latest, but second latest value

    Currently I'm using the below formula successfully to bring up a date of a latest left digit in a sequence of two digits: {=LOOKUP(2,1/("0"=LEFT(C:C,1)),A:A)} What I want is the same above formula to instead bring up not the last date but the second last date. For example: April 16, 2018 13...
  7. S

    finding a text in multiple fields and then get the max of a date field field based on that text for Google Sheets.

    Hi, I have a dataset where it has a Date field and there are 4 or more than 4 'Resource Name' columns. The name could be repetitive in each column but it will not be repetitive in each row. Now, I have a list of unique resource name and I need to find out the max Date for a particular resource...
  8. A

    Lookup: If a cell contains a string, return a value from an array

    I'm curious about the best way to search a cell, and if a specific string is found then return a specific value based on an array of outputs. Here's the current formula that I'm trying and I'm not sure what the issue is (I'm on Excel 2019 for Mac if that is a potential issue)...
  9. D

    Lookup multiple criteria

    Hello I have looked online and tried multiple different suggestions but I must be doing something wrong as I cant get the desired result. What I want to do is. In cell A60 is a Data validation list derived from all of the names in cells A2:A55 In cell A61 I wanted a formula to look for the...
  10. T

    Sum of multiple Cells to give date when it meets criterion

    Hi all, i have rainfall data for 3 years. I want a formula that can give me the day of the month once total rainfall from 01 Jan is equal to 51...
  11. opazzo

    Weird Data Structure - VBA to join to tables ?

    Hi there, I have two sheets with a common key "CardName". One sheet has properties (first table below) that I want to copy to the second sheet after the last column of the second table. The first row would be headers and the second row repeated for each item with the same card name. The...
  12. W

    Return MULTIPLE corresponding values for TWO Lookup Value, Horizontally, in one Row

    Similar to this link(reference the bottom)- I am trying to return multiple corresponding values with two look up conditions, horizontally, in one row. Then I can apply it down other rows. Not sure how to go about this- I have been stuck for days. I provided a sample below: ID Name Qty A...
  13. D

    VBA or formula to run a look up based on a cell value

    Hi All, i have been looking at many different ways on how to do this, its more than likely very simple but i just cannot figure it out. i want to look up a value in another sheet based on another cells value. i can get the formula to work on every cell but i just want it to run for the "No"...
  14. A

    VLOOKUP greatest value of multiple text inputs

    Dear Community, I am currently trying to do a VLookup and I was hoping you guys could help me save some time. I want to lookup multiple text inputs and return the greatest value among those inputs. I am sure this is a simple task and I am afraid I have over complicated it. This is for a...
  15. S

    Need quick help with calculating the below

    Need quick help with a formula I have the following data in excel. Based on the row label value in the description column, it has to go to the corresponding column label, and have to extract the intersection value of row and column. Can you please provide some guidance. I tried various...
  16. K

    Conditional formatting look up into a table/named range

    Hello :) Please could someone help me write a formula, that looks up between workbook1 and named ranges/tables on workbook2. In book1 I have a "Role" column (D) and then a "Name" column (E). In book2 I have named ranges (also made into tables) that are headed with a variety of roles. One of...
  17. B

    Look up cell in an array and then return the value of a cell in that same array relative to the

    Hello, I need to look up a cell in an array, and then return the value of a cell in that same array relative to it. For example: A1 = 1/1/2018 B1 = 2/1/18 C1 = 3/1/18 D1 = 4/1/18 E1 = 5/1/18 A2 = 2/1/18 A3 = 2 A4 = 4/1/18 A4 was found by looking up A2 in the A1:E1 array...
  18. C

    Look up formula based on two criteria

    Good afternoon, I need some assistance on finding a formula! Jumping straight to the point, here is my predicament: <tbody> Customer # Customer Name Master Price Level 0001 0002 0003 0004 0005 x apple 1 y ibm 2 z dell 3 </tbody> I am trying to look up a value under...
  19. M

    Return non-zero data and associated row header from an array

    I will be grateful for help with the following I have an array in the following manner: 31/01/2018 28/02/2018 31/03/2018 30/04/2018 31/05/2018 30/06/2018...... First 120 0...
  20. B

    Max, Lookup, Sumproduct Complexity!!

    Hey everyone! I can not figure this out right now to save my life...so I need help I need an equation that does the following.... "Take Rate" Tab cells BM7:BV17 represent how many of the part called out in cell B7 is in each of the full products shown in cells BM6:BV6 "Volume Summary" Tab...

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