#match

C D E F G Session Code Demo Practical Lecture Seminar D01 3 3 D02 3 3 In the example table above, I would like to write a VBA code to list the Session Code + Lesson Type like this D01 Demo D01 Practical D02 Lecture D02 Seminar I was able to look for a code but it just gives...

Hi, I receive shifts from one source in a table and I have the availability of staff in another source in a table. I would like to return the name of the staff that is available in the column 'Name' in the Shifts Received table. I have tried using INDEX and MATCH but I'm struggling as I need...

Hi there, I am having no luck with my index match formula. I am trying to create a formula that will match with the following criteria "Apple" and "FY19" to return the number 200. If anyone can help that would be really appreciated. Any suggestions on formulas? <tbody> Opportunity# Apple...

Hi, I have two lists of Accounts that I need to consolidate. These lists come from two different sources and in a lot of cases the individual names are slightly different. Ie One list has 'AC Nielsen', the other one has 'Nielsen Media'. The best tool I have found so far is a partial Vlookup...

Here is the table to help you understand the problem. <tbody> r1 8B GA ID IL IN IW JT QG ABU-KOE 14 AEG-KNO 7 AMQ-BXB 1 AMQ-CGK 14 35 14 7 Routes Competitor ABU-KOE IW AMQ-CGK GA, ID, JT, QG </tbody> What...

I am trying to create a smart #. So far I have tried using the concatenate function alongside v-lookup. As well as a variation of index/match nested within if statements. I either get an error (tried iferror), n/a (tried ifna) or #ref , which means the range is probably wrong. Attached is a...

Hi All, May i kindly get your help on an excel formula? I am trying to match 3 criteria between table 1 and table 2, namely: "Order", "Amount" & "Stage" and return the values to Col D & E respectively. For example, if Table 1 Row 3 has "OrderA", Amount of "5" & Stage is "sent" and Table 2 has...

I have the following scenario <tbody> Package SKU Individual SKU 8000P 12345 8000P 12370 8001P 12345 8001P 12350 8001P 12382 </tbody> I want my data to look like this, I need help with bringing the individual SKUs across columns so that each row is unique. <tbody> Unique Package...

Hi, I would be extremely grateful for your help. I am trying to get match dates in two different arrays, both declared as variants and regardless of whether or not the dates actually match I get an (Error 2042). I have reproduced the code below. How the code works:tsdata() = loads an array of...