#index

Hi, I'd love to receive some feedback about have the right formula for this problem, I'm getting crazy so bad because I understand what I need but regardless I can't find the right formula. I explain what I am looking for: I have this first table, Column where the RATE is have to show the price...

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 have a workbook which has data for different projects. Each project has categories and monthly data, using powerquery an index column was created in order to define the relationship between the monthly data and categories. https://www.dropbox.com/s/l5b3oes2ovg092n/datamodel.PNG?dl=0 My...

Hello All, I am looking for a formula which will look a value from a two lists and list its corresponding value in result. Please refer the table below <thead> Lookup Value </thead><tbody> Item_1 List1 Lsit2 Item_1 Item_2 Item_3 Item_1 Item_1 Item_3 Item_2...

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