Please can anyone explain??!

Jules2016
Jules2016 Registered Posts: 5 New contributor 🐸
Hi I'm so stuck on the sample assessment on AAT CBT1 the very first question:(
In the worksheet called ‘Invoices’ use a lookup function on the ‘Item No’ data to calculate the net sales using information from the Price List worksheet.

Help

Comments

  • salma1011
    salma1011 Registered Posts: 41
    = VLookup(C7,'Pricelist'!$A$5:$D$12,4)xD7
    Explanation
    You want to find the price of 1 item code 35698 from the price list
    = Vlookup
    then click on C7 ( item number 35698) then add , (coma)
    click on Price list (work book)
    select from A5 to D12
    then add , (coma)
    then 4 ( price from column 4)
    then multiply by D7 quantity sold
    Don t forget to add $ to block your cells as you want to use them for all
    Then put your cursor on the bottom right corner of cell H7
    You ll see a black cross double click
    All done
    You will use V lookup as the info you want is in the column = vertical otherwise if it was in a Row you will have used H lookup

    Not sure it is clear enough
  • Jules2016
    Jules2016 Registered Posts: 5 New contributor 🐸
    Oh my God you're amazing!
    Thank you so much x
Privacy Policy