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


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

Some videos you may like

This Week's Hot Topics