lookup and match

SHEET 1 PATIENT NO. | SERVICE DATE | PATIENT STATUS 1 | 08/01/2015 | ? 2 | 09/25/2015 | ? 3 | 04/03/2016 | ? 1 | 05/15/2016 | ? 3 | 05/20/2016 | ? SHEET 2 PATIENT NO. | SERVICE BEGIN DATE | SERVICE END DATE | PATIENT STATUS 1 | 08/01/2015 | 08/30/2015 |...

I am trying to good way to concatenate items that are grouped by a column but excludes the item in the current row. The only reference I could find to a similar task was here. But this is a fairly manual method and I wonder if there is an easier way to do this with a macro especially with a data...

Hi, I'm working on a resource model which has names in column A, dates of employment in (mm/yy) format across row 1. I have the names of employees, and how many days they have worked per month over the last 2 years. As an example you could see: <tbody> End Date Feb-15 Mar-15 Apr-15 May-15...

I have the following formula LOOKUP($A12,$A$3:$A$8,$D$3:$D$8) which is a portion of another formula to find the corresponding value from the prior week results by team to the current week results. The goal is to create a formula to calculate whether the current result is => than the prior result...

<tbody> Calendar Code Country Person Date Alex Mark John Mark and John, No Alex ABB Antigua and Barbuda John 10/01/2017 J ABB Antigua and Barbuda Mark 05/01/2017 M ABB Antigua and Barbuda Alex 04/14/2017 A ABB Antigua and Barbuda John 05/01/2017 J </tbody> I need to...

I apologise in advance if this is a confusing post! At the moment I have a table of different investments in column A and in the columns adjacent I have the percentage allocation to each risk profile. The simplified table below should explain better. <tbody> Investment Low Risk Cautious...

Hi, would like to know how can I execute reverse look up or index match using vba macro? My worksheet looks like this: Row Column A Column B Column C 1 Process Subprocess Ref. Indicator 2 Reporting Statutory FO/RM 3...

Hello, I'm trying to figure out if this is possible. I want to use a vlookup (or any formula) to return the lowest value of 5 specific values. We have 7 INDIVIDUAL MODEL NUMBERS. Then we have PACKAGE MODEL NUMBERS that include 5 of the INDIVIDUAL MODEL NUMBERS. In (Column D, Rows 2,3,4) I...

I have a yearly Summary tab (see below) which tracks the amount of chains sold per week. Column A is week beginning and Column B is "Chains", I have several more items but just need to concentrate on one as I will be able to work out the rest once given the first formula Week Beginning Chains...

I'm looking for a Macro to run that will lookup "Project #" in Sheet 1 (named ProjectID), copy its adjacent cell value on the right, look for every time the word "Project #" appears in the remaining sheets and paste the previously copied value into the adjacent cell on the right. [e.g. Project...

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

Hi! Thank you so much for having this site. Not sure what I would do without all of you! Here is the data: -- removed inline image --- I need to write a function or formula in the RESULT column. But the formula needs to look in the Occasion column and find it's MATCH in the Category...

Hi, I need help with a LOOKUP formula with multiple criteria. I am using Excel 2010. So basically i need to return a pre-determined price range bucket but the price range buckets are different for each Div/Dept. Example of data <tbody> Row Division Department Price Price Bucket 1 mens...

Hello, I have a table that tracks players' achievement scores based on hours of practice: player names M1:S1, hours of practice L2:L30. In cell V2, I enter the number of hours of practice. Using that figure in a lookup, I need to generate a ranking of the players in cells V5:AB5. Right...

Hello. I appreciate your help on this: Cell A1 contains the name of a supervisor. Cells in A2:A20 need to be populated with the names of the supervisor's employees. A sheet in the same workbook named All Teams contains a table listing all supervisors and their employees columnar format. The...

Hi All, I am hoping someone can help me figure out how to pull back a value based on multiple for a large data set that I can repeat in the spreadsheet thousands of times without crashing excel. The problem I have relates to a data set like the following: <tbody> A B C D E 1 FROM_DATE...

Hi folks, I hope you can help, I'm trying to run a PO/budget sheet with 4 currencies in it. I'd like to have a column at the end which calculates my monthly outgoings in GBP, using a fixed exchange rate. I'd like the function to see which column (B/C/D/E) has a figure in it, convert it to GBP...

I get daily bids from different vendors for a commodity. In the column out to the right I want to put the daily minimum bid (got that part figured out) and the vendor with the lowest bid. I have tried to use the lookup function, but because the bids will never be in ascending order that...

<tbody> Weight From Weight To Weight Category Route 1 Route 2 Route 3 Route 4 Route 5 0 30 1 43 20 35 28 41 30.01 50 2 43 20 35 28 41 50.01 75 3 52 25 40 35 49 75.01 100 4 55 29 43 39 53 </tbody> Hi there, I’m trying to work out a formula to...

Hi, I am trying to automate some of my product upload CSV files, I have the below in Columns A to C. <tbody> Item Name Matrix Type Sub-Item of Test 1 - Main Item Parent Test a Child Test b Child Test c Child Test 2 - Main Item Parent Test I Child Test II...