excel multiple lookup

  1. K

    Excel lookup using multiple criteria

    Hi, Below is a sample table which I need to extract data from: <tbody> Event Name Location Feb Feb Feb Feb Feb Feb Feb Feb 04-Feb 05-Feb 06-Feb 07-Feb 08-Feb 09-Feb 10-Feb 11-Feb Event-1 Loc-1 Yes Yes Yes Yes Loc-2 Yes Yes Yes Yes Loc-3 Yes Event-2 Loc-1 Yes Yes...
  2. R

    Excel: Return multiple corresponding values for multiple lookup values

    Hello, I'm sorry if this question has been asked already but I've been looking for an answer for a while to no avail. I would like to know how to lookup multiple values using multiple criteria. Let us say that in column A are last names, in column B are first names, and in column C are phone...
  3. T

    VLOOKUP MULTIPLE COLUMNS

    With the knowlege that I have of Excel, VLOOKUP is the best function I know of to look up and match to other data in a workbook. If there is another way to do this please let me know. I need to use 2 columns in a data array to match in order to be supplied with the correct item number that is...

Watch MrExcel Video

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