Results 1 to 5 of 5

Excel 2007 : Multiple VLOOKUPS or MATCH or both?

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2008
    Posts
    13

    Arrow Multiple VLOOKUPS or MATCH or both?

    I have a problem getting a VLOOKUP to work with a match funtion.
    I have two tabs in my spreadsheet: one is titled DATA, the other ACTUALS.

    What I need:

    Lookup supplier (COLUMN AV), plant number (COLUMN D), purchasing group (COLUMN H) and new type (COLUMN AX) in Tab "Actuals", if all four are found [matched] in the other tab "Data" then return savingsplan ID [which is a six digit number] in Column A.

    VLOOKUP is not working so well with this one as I have multiple values that have to match before it returns anything.

    Does anyone have any ideas? Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1