+ Reply to Thread
Results 1 to 2 of 2

Lookup or If/And formula help

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Lookup or If/And formula help

    I have a table of data that I want to auto populate the correct information based on a selection from 2 lists in another table The data isnt exactly what I have in my table but the concept is the same. The table is below and starts with A1:


    Group Group Price Balloon Slingshot Dart Water gun
    A $10 $15 $10 $5 $1
    B $20 $14 $10 $5 $1
    C $30 $13 $10 $5 $1
    D $40 $12 $10 $5 $1
    E $50 $11 $10 $5 $1
    F $60 $10 $10 $5 $1

    The table that the formulas need to be entered in is below and starts in another worksheet on A1:


    Item Item Price Group Group Price Total
    Balloon (formula) A $10



    The formula that i'm having trouble with needs to cross reference the cell A2 and the cell C2 and return the proper price from the table on the first worksheet above. For example: A Balloon in group D would return the price of $12 according to the table. For whatever reason I'm having a brain fart on how to get this accomplished and have been staring at it too long and need a second set of eyes. I'm not an excel master by any means but can usually figure out small stuff with formulas.
    Last edited by indians724; 08-07-2012 at 12:22 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Lookup or If/And formula help

    Try
    =INDEX(Sheet1!A$2:F$7,MATCH(B1,Sheet1!A$2:A$7,0),MATCH(A1,Sheet1!$A1:$F1,0))

    Where Sheet1 is your first table
    Sheet 2 is your second table
    B1 is the description of the "weapon"
    A1 is the group letter
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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