help for excel

Discussion in 'Software Q&A' started by Cool Buddy, Nov 7, 2006.

Thread Status:
Not open for further replies.
  1. Cool Buddy

    Cool Buddy Active Member

    Joined:
    Mar 31, 2006
    Messages:
    1,590
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Milky way
    I often have to make lists of some items which is like a quotation for the buyers. I have all the items and their prices listed in a separate sheet. For the name of the items i use drop down menu. Is there any way so that the price is taken automatically in the cell on its right?
     
  2. tuxfan

    tuxfan New Member

    Joined:
    Feb 4, 2004
    Messages:
    2,653
    Likes Received:
    9
    Trophy Points:
    0
    Location:
    Mumbai
    How many items are there in the drop down?? May be you can use the iif() or if() function. I don't use excel anymore, so don't remember whether its iif or if. But the syntax is

    if (condition,action.true,action.false)

    So you will have to use nested if(). But if there are too many items, it will be very inconvenient and you may have to take help of macros (VBA).
     
  3. Ramakrishnan

    Ramakrishnan The Researcher

    Joined:
    Mar 7, 2006
    Messages:
    1,154
    Likes Received:
    10
    Trophy Points:
    38
    Location:
    Mumbai
    use vlookup. Before using vlookup sort your data.
     
Thread Status:
Not open for further replies.

Share This Page