look up

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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