2 way lookup

  1. W

    Dynamic worksheet look up - index match 2-way look up

    Hi there, I have an index match match 2-way look up, which returns data based on another tab. (The index match does a vertical look up and then a horizontal one). The formula works fine, but I would like to introduce a variable into the formula to so it looks up the 'correct' tab, corresponding...
  2. K

    2 way Lookup array formula with Duplicates

    Hi All, I am am performing a 2 way lookup within the array below, based on "Month" and "Name", to return the intersecting value/blank. This works fine, however I need it to return the last value if the "name" Column has a duplicate. (For March I want Jane to display 150, instead of " - ")...
  3. M

    Two way lookup for text from different sheet

    I have been go crazy trying to figure this out... I hope someone can help! I have a data table that I need to populate from worksheets submitted from various departments. The challenge is that each department uses differing systems, so the table that I need to assimilate the data into...
  4. L

    index match with the lookup column having ranges

    Thanks in advance for any suggestions. I am trying to do a 2 way lookup using index match. The first part of the match will be to the column A2:A10 where the values are arranged in ranges. A2 would be 1-5, A3 would be 6-10, A4 would be 11-15 ect. So I can't seem to make it work but I think it...
  5. W

    Creating a table, from a list, with two variables

    So here is the challange.... Below is a portion of the table I am using. FormID is a number that duplicated for each of the unique Element Names. There are 30 different fields that the Element names could be (name, phone No, etc). If you start NEW WORKSHEET and create a table (FormID in the...
  6. N

    2 way lookup with varying row/column headers

    Hi All, Guess the title sums it up but need to have a macro that will return a value dependent on the row and column. Accept a sime Index/Match/Match set up will handle this, however, the row headers and columns might be in different row and columns as the sheets from which the data is...
  7. I

    Kind of a 2 Way lookup but not really

    Hi, I have a workorder that looks like this: <table style="border-collapse: collapse; width: 749pt;" width="978" border="0" cellpadding="0" cellspacing="0"><col style="width: 129pt;" width="172"> <col style="width: 20pt;" width="26" span="31"> <tbody><tr style="height: 13.5pt;" height="18">...

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
Back
Top