lookup functions

  1. H

    Excel VBA - using lookup functions on a two-dimensional array

    I am trying to figure out how to use Excel lookup functions (such as VLOOKUP, HLOOKUP, INDEX, and MATCH) to return the data according to certain criteria from a two-dimensional array. Let's say I have an two dimensional array like the following: Sub LookupArray() Dim MyArray(0 To 1, 0 To 3)...
  2. K

    Lookup Multiple Columns for Value to Input

    I have a spreadsheet of employees, with multiple positions, at multiple stores, and multiple pay rates, as below: <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> H John Cook 10.00 K John Porter 9.00 E Bob Cashier 8.00 H Bob...
  3. 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...
    • jakup5031
    • Thread
    • if formula help lookup functions table array table look up
    • Replies: 2
    • Forum: Excel Questions
  4. S

    Multiple Column Lookup

    I'm putting together a lookup tool. The columns are types of cars (trucks, SUV's, vans, cars), paint colors available on each car (green, red, blue, yellow), and the third column is the car name (F150, F350, Envoy, Astro Van, Grand Prix, Grand Am). The fourth column (which is the column...

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