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

    Vlookup value From Another Table And Save it to Other Table

  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top