table look up

  1. M

    Help please index match/vlook up

    Hello everyone, First of all, I would like to thank you for taking the time to help me out. Here is what I am looking to do: -I have a table with categories that have a rate value for certain periods (dates) (Given) -Then I have another(second table) table that have the same categories, start...
  2. O

    Looking Up the intersection point in a table that matches multiple criteria

    I have a list of cities in column A with a set of values assigned to them in column B. Is there a formula I can use to determine which cities values would go together with the sum being between two numbers and without including more than three cities. For example if the range that the sum must...
  3. W

    Easy question: Macro to search all the records of a field and copy specific records into a different table

    Heya, I'm afraid I'm mainly an excel person and adjusting to the differences with access and I'm trying to create a new table out of only a select few records based upon a different table. The Scenario I have two tables, CB and CB1, CB is the new table that I want to be made of specific...
  4. smatterchu

    My custom list is >2,000 character - how can I custom sort this spreadsheet?

    I have monthly reports that need to be sorted in an order other than ABC. I have the proper order of each product, and the list is 79 separate items/rows (over 2,500 characters). I tried to create/import a custom list and ran into the character limit. How can I set up some sort of lookup...
  5. H

    VLOOKUP and IFERROR

    Hi, I have an excel project that I need a lot of help with :( I can't seem to grasp nested IF's or VLOOKUPS. Here is the information Product pricing is A1 subtotal and shipping cost are D2 and E2 then the list of product supplies are A3 thru 17 and under worksheet named product prcing and...
  6. J

    IF Formula, Excel 2010, Choosing in table only those items that are present on another table/list

    I have established two tables: the first being records over a long period of time(lets call it "AllTime"), including names; the second being only the names of current employees (lets call it "Current"). I am trying to establish an equation in a column of the "All-Time" table where if an employee...
  7. T

    Double range data selection(?). Lookup of 1 output value given 2 inputs belonging to defined ranges

    Hello everyone This is probably not a new issue, but was not able to find anything on it FYI - I am using Excel 2007 It will be much easier to understand if you look at the example table below (I am not able to post an image, sorry...) I am given the table with assigned values, plus couples of...
  8. J

    Hide Columns & Rows VBA - Thank You In Advance

    I am somewhat a novice with VBA, in other words, I am still learning. I am trying to write a vba macro that would hide columns based on what is presented in another table. This will allow me to update the table and not have to worry about updating the macro on a continuing basis. For...
  9. K

    Two-Way Lookup function within named range

    I hope someone can help me out with this, I've been looking all over the net for ages. I have a table I want to perform a 2-way lookup on. I have given it a name, "Testing", which includes the header, row title, and all the data. So for example, I have: A B...
  10. D

    Single Range - Reference Repeated On a Single Sheet

    Hi All I wonder if someone could please help me solve this issue, I have asked on some of the newsgroups and had no replies or people who think they can solve it and never getting back to me.. might be an ego thing What i am trying to do is I have a table price grid for a product let say...
  11. D

    Report the value of an intersecting row and column, without numbering the row and column

    <TABLE style="WIDTH: 197pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=263><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=3 width=64><TBODY><TR...

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