+ Reply to Thread
Results 1 to 2 of 2

Lookup problem

  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    63

    Lookup problem

    Hi, I have a bit of a problem with a lookup. I'm not quite sure how to use Index & Match in this situation. I enclose an example of the type of data I'm looking at. In this example I want to look up the Sales value for the Title that is in Position 1 (ie. 5000).
    Is there a way of doing this?

    thanks
    Liam
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,601

    Re: Lookup problem

    Maybe something like this:

    =SUMIF($B$2:$B$30,"War & Peace",$E$4:$E$32)+SUMIF($B$2:$B$30,"War & Peace",$E$5:$E$33)

    where "War & Peace" you can change with reference cell (i.e. G1)

    Watch ranges!

+ 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