Results 1 to 27 of 27

Vlookup, Index or Match?

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Queens, NY
    MS-Off Ver
    Excel 2007
    Posts
    17

    Vlookup, Index or Match?

    I have a spreadsheet that I am trying to get and exact match on a summary page. The criterias are
    if the data in B3 & C3 matches the data on a separate tab but same cell references then the data from cells F3:BR3 should be exact for all for all cells that have the exact same criteria as B3 & C3. To explain myself further. If a cell b3 have a # of 00057 and cell C3 have a nuber of 058 then all cells in those two columns that match those criteria should have the same percentage from column F5:BR2631.

    This is an index formula I am trying and I am getting #VALUE! ERROR. Would VLOOKUP be better and can someone assist me with the formula.

    Also cross posted here
    http://www.mrexcel.com/forum/excel-q...dex-match.html

    Thanks
    Last edited by cwallace70; 09-07-2012 at 01:09 PM.

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