double lookup

  1. A

    VLOOKUP Several sheets VBA

    Hi. I have a VLOOKUP-problem I hope you guys can help me with: The input: 1) I have several worksheets in a workbook. Each worksheet is representing a project with financial figures. There is about 100 projects, so there are about 100 worksheets in the workbook. The names of the worksheets are...
  2. khawarameer

    Lookup for Horizontal and Vertical Search

    Dear All, I have two tables, in table 1 i have a statement of more than one customers combined in sequential order, in table 2 i have customer numbers vertically placed and dates horizontally placed. i want to use a lookup function which may extract day end balance in front of each account...
  3. L

    VLookup + Match functions for two column lookup with multiple words

    Hello, I am attempting to create a sales quote creator. I have a product database in one sheet with product number, product, product options, and price in each column. I then have the 'sales quote creator' in another sheet with a dependent dropdown list (with product options being dependent on...
  4. 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...
    • TonyHP8
    • Thread
    • double lookup range filter table look up value between
    • Replies: 4
    • Forum: Excel Questions
  5. L

    Search Matching 2 keys

    I'm trying several options but no one works. Let's see if anyone can help me. I have a sheet with country information, like: <table width="923" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 76pt;" width="101"> <col style="width: 48pt;"...
  6. H

    Referencing a cell containing a reference formula

    Thanks to this forum through which I got help & now in my workbook, in Sheet1, in cell address F9, I am able to fill a value present on Sheet2’s cell address M17 using ‘indirect’ function instead of a simple Excel function like F9’=Sheet2!M17’. In Sheet3, cell H6 I want to do FURTHER REFERENCING...
  7. D

    Complicated double lookup

    hi all, i have this complicated double lookup that i have to create a formula on. this will determine the price based on item no and customer. suppose the table looks like this: <TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=384...
  8. B

    Double lookup from two dimensional table

    Hello all, I am trying to get a cell in my spreadsheet to look up a value based on two values. I have a dropdown list that lists the worksheets in the workbook, and each worksheet has a table with width measurements for the columns and height measurements for the rows. I have a function that is...

Watch MrExcel Video

Learn Excel - Slicer For Two Data Sets - Podcast 2198

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