lvlvlv
Level 1 (4 points)
iWork

Q: auto filling pricing into invoice

I am very new to this and am struggling with bringing data from a basic stocklist I have complied as a sheet , into a second  invoice.

 

I deally I would like to type the name of the product into a cell and have it fill another cell with the price based on the calculations occuring in the stocklist

MacBook Pro, yosemite 10.10.5

Posted on Sep 10, 2016 8:45 PM

Close
lvlvlv

Q: auto filling pricing into invoice

  • All replies
  • Helpful answers

  • by t quinn,

    t quinn t quinn Sep 10, 2016 11:09 PM in response to lvlvlv
    Level 5 (5,012 points)
    Mac OS X
    Sep 10, 2016 11:09 PM in response to lvlvlv

    Hi lvlvlv,

     

    Here is an approach that uses both INDEX and MATCH. LOOKUP and VLOOKUP cover the same territory but INDEX/MATCH is clearer for me.

    Screen Shot 2016-09-11 at 12.03.17 AM.png

    B2= INDEX(stock list::B,MATCH(A2,stock list::A,0))

    INDEX is looking for the value in stock list::column B that is in the same row as the value in A2 of invoice.

     

    quinn