dynamic lookup

  1. 1

    VBA for lookup when no. of rows changes?

    Hi, I've written this macro to add a lookup formula in column Z if there is a value in column A and it works fine for this month. The only problem is it will only cover as far as Z 681 as that's how many rows are in column A this month but next month it might be 600 or 847, I simply don't know...
  2. C

    dyanmic lookup function?

    Dear all, I am trying to find a formula that will return a value in the "Value" column in the small table to the right of the larger table. i.e next to cat 1 ref 129 should have a value of 182,500? Can anyone help? Thanks Chris <tbody> Cat 1 Cat 1 Cat 1 Cat 2 Cat 2 Cat 2 Cat 3...
  3. S

    Dynamically adding values in several sheets with For..Next loop and Application.WorksheetFunction.HLookup

    Hi there, I have this certain code that I need to implement. Basically I have to add values in several sheets based on hlookup. However, the names of the lookup tables in each sheet are worksheet-scoped and similar for scalability, and I have no idea how to implement the hlookup function in vba...
  4. G

    Dynamic lookup value requires correct syntax

    Hi, I am trying to create a lookup that will get the parts with the highest chance of being used depending on the location. I figured out the formula in Excel, but I needed to convert into VBA. I used the recorder, but I need to add a variable to the formula, so the lookup value of my formula...
  5. H

    SUM results of various dropdown list outputs

    Hello Mr Excel, Based on six Segments (which I select individually in a drop down list) I am building result tables for each segment. Example: I select segment CONSUMER in the drop down and the result table returns a long table with revenue, cost, volume data for MASS. All this result data...
  6. W

    Dynamic Lookup Help

    I am creating a waste management document for construction projects to give to our clients. I have 4 boxes with headers: Landfill, Incinerated, Recycled, Reclaimed. Below those boxes, the client will have to total up the receipts and put the amount in either tons or cubic yards of waste for...
  7. A

    Use cell text as a cell comment of another cell

    Hi there, I have another question that I hope someone can help me with this time. (It appears that my first question was a real stumper! See http://www.mrexcel.com/forum/showthread.php?t=421823) My spreadsheet has a dynamic range dropbox validation in Sheet 1 Col T. What I would like to...
  8. J

    Custom VBA VLookup Formula

    I'm having a hard time getting a custom vlookup formula to work. I need to be able to change a part of the range in the vlookup dynamically based on a cell value. This is what I came up with but it gives me a value error. Can anyone help? Function VL(val As Variant, RNG As Range, col As...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top