lookup table

I have a master table with values. My master table has a TagId column with values such as TagId: 123,321,344,455 and a combination of one value, two values, four values etc... (all comma separated). These numbers correspond to campaign names and these are in a separate table, i.e. 123 This is a...

Hi everyone. Has anyone ever used a large table (2 million rows) in power query as a lookup table in a regular vlookup formula in an excel sheet? I'm not talking about a vlookup between 2 tables in power query itself. The large lookup table would be in power query and I want to use a vlookup...

I am a beginner to Power BI and really appreciate your help. I have 20 offices. Each office has 5 units and each unit has 3 sub units. I set up the following lookup tables: Office - office #, city, state, region Unit - Unit # and Sub # The Office lookup table works and slices and dices all...

Hi, I have question about best practicies to use Table1 with lookup fields delivered from another table (Table2) - but lookup list values is depend on another field in this Table1. This is a classical problem with nested lookup list of available values delivered from another table with values...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi All, I currently use a VLOOKUP function to merge details from one sheet into another, basicly I have a lookup table in the second sheet. The formula is like...

I am working on a worksheet to lookup values from a table. I am having a problem figuring out the row and column dynamic lookup. I have two pieces of information. For example, 4 and $21,000. With these two pieces of information I need to be able to look across the top row to determine where 4...

I am trying to do a lookup from a table based on 4 criteria. 3 criteria are entered via drop down lists, and one is a constant. See below. I need a formula that will deliver the results in F10. I believe there are several ways to acomplish this, I think with Index And/Or Match, but I am having...

I've been working on this project for quite some time, and I've found solutions that get me close, but don't solve my problem. I typically like to figure things out on my own, because I feel that's how you learn best, but after months of work I'm finally breaking down and asking for help (mainly...

How can I store a lookup table in vbe module instead of a worksheet (hidden or visible). Is this possible? Or, could I pull the contents out of an existing lookup table, delete the workhseet, and have vba add a new worksheet and recreate the table? - Thank you, Rowland