lookup array

Hello! I have a workbook that lists products we sell, for who, when and how many we have sold of each product. I would like to add macro into workbook, which based on multiple criterias can figurate the exact matching and return the requested relevant information, what I need. To simplify my...

Hi All, My issue is probably simple, but Im in a brain fog! I have 2 columns, in A, I have a list of lesson numbers, and in B a list of unique subject IDs. Example 1 1.1 1 1.2 1 1.3 2 1.4 2 1.5 3 1.6 3 1.7 1 1.8 1 1.9 2 1.10 What I want to do is return only those...

Hi all, Its been a while but I find myself completely stuck once again, any help is greatly appreciated. I have a workbook with a sheet Data_sheet with a report on that's updated regularly. I have been asked to create a dashboard (and accepted before I realised VBA is not an option) What I...

Hi, I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15. Order ID Name Poule Number Victories Prop Indicator 845.3333333 James 1 5 0.83 12 497...

Hello - I spent the past hour or so searching google and the forums. I can't find exactly what I'm looking for and that's probably because I don't know exactly what I'm looking for. My real goal is to find and highlight cells that did not get summed up. I.e. if I have a sumifs formula with a...

I have data similar to what is in the table below on one worksheet and I'd like to create two tables on another worksheet (one for "Upper" and one for "Lower" type). I was wondering if it's possible to create a lookup formula that looks at the "Type" column and displays the entire row of data...

I have two worksheets. One has a project Code with corresponding reference codes in the cell to its right. Altogether there are several hundred project codes and about five corresponding reference codes which match. (More than one project code can match a single corresponding reference code but...

Hello everyone, I hope you can help me with this, I've been struggling with it for a while. I have a large spreadsheet with over 100,000 rows. I need to find the largest number associated with a users id, there are multiple values associated with the user ID but I want to return the largest...

Giving an example because its very hard to explain. IE: I have formulas that searches for employee names on sheet 1, A2:A15. All ten rows are locked with those formulas and formatted as "text". Some rows are blank and some have names in it. I am on sheet 2, and I want to transfer those the...

I would like to make it so the data on a separate sheet can be looked up,without having to manually outline the data each time. Normally the formula would look as follows, referring to tabulated data on sheet antistatic. Along the left is date&time values and across the top are unique labels...

I'm using the lookup formula below to search user comments in cell B1 to find individual words listed in column C, and return the adjacent number value found in column D. =LOOKUP(9999,SEARCH($C$1:$C$837,B1),$D$1:$D$837) The problem I'm running into is that excel only returns the number value...

Is it possible to search row 1 (headers) for a value defined by a table from another sheet. example row1 = One, Two, Three, four sheet 2, column A:A = five, six, one, seven. if sheet 1, row 1 contains any of the values listed in sheet 2!A:A, I need to have an output of true, or msgbox or...

Please help me figure out an array formula to return unique values from certain columns of data. The source data is on a sheet with columns labeled for different committee groups, i.e. <tbody> Safety Finance Social John Gail Steven Betty Mark John Bill John Mark George Steven...

I think I've got a pretty simple one to solve but I can't seem to find the answer within the mrexcel forum. I want to get the Suburb entries of particular customers. The INDEX and MATCH combination works well until I get to a blank entry, this is the formula I have been using, simplified for...

Hello! I am a bit stumped here. I am working on a workbook with 2 worksheets and I need to figure out 2 formulas: Worksheet 1 contains (among other data): <tbody> A N O P Participant name <tbody> Month Started (First Session) </tbody> Month Completed (Month of Last Session) Current...

I was asked for help with this and used a function I've not used in a while. I don't see much discussion of this so thought i'd mention. problem: a range of numbers and letters. Each letter representing a number (for some undisclosed reason). A lookup table was available to provide the letter...

Hi, Apologies for posting another Index/Match thread, but I think I've been through them all now and I'm still struggling. Index/Match is my Achilles Heel so apologies if this is straightforward. I have a summary tab displaying stats on various sites (each site has its own tab). An example of...

Hi, I am looking for some help with a problem I don't have the skills to solve by myself. I don't have any VBA knowledge, so will be particularly appreciative of any formula's that can solve the problem. I have a table of unique 6-digit references in a grid (i'll call this the 'table') Table...

Hi, I have been trying to create a formula that will return a value from a table if it is within a range of dates. I have tried several different formulas based on answers to similar questions, but none seem to work for some reason. Here is a a summary of my table. I want to return the value...

Hello, I'm trying to use and array lookup formula to help identify where a value falls in a range of numbers. Here is the table with the ranges and corresponding identifiers: 0-60 A 60.01-70 B 70.01-75 C 75.01-80 D 80.01-85 E 85.01-90 F 90.01-95 G 95.01-97 H So let's...