+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Match using Index or Vloopup for value

  1. #1
    Forum Contributor
    Join Date
    10-16-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    112

    Match using Index or Vloopup for value

    How can I match the meals and meat with the two tabs in cell C2 under tab Volume and then pick the value between count and volume in tab count

    If the two numbers are the same for count and volume, it should show that number, but if they aren't the same, the lower value should appear.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor khamilton's Avatar
    Join Date
    10-08-2009
    Location
    IL
    MS-Off Ver
    Excel 2007
    Posts
    345

    Re: Match using Index or Vloopup for value

    can you show your expected results in your sample.
    Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  3. #3
    Forum Contributor
    Join Date
    10-16-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Match using Index or Vloopup for value

    Here is what I am looking for
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor khamilton's Avatar
    Join Date
    10-08-2009
    Location
    IL
    MS-Off Ver
    Excel 2007
    Posts
    345

    Re: Match using Index or Vloopup for value

    Here is what i could come up with. HTH

    Volume.xlsx

+ Reply to Thread

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