Turn on thread page Beta
    • Thread Starter
    Offline

    2
    ReputationRep:
    I tried looking up tutorials online but I don't really get the explanations so could some one help explain solve this question. It's from the ICT level 2 2016 june paper . The question is: Use a lookup function and the information in cells I5 to J8 to enter the Re-order Level for each product. I have a table with product types, product names, description of the product, opening stock, stock sold, Remaining stock and an empty coloumn for the Re-order level. There is also cells I5 and J8 which is a smaller refrence table with product types and some re-order levels.
    • Very Important Poster
    Offline

    21
    ReputationRep:
    Very Important Poster
    (Original post by Sophie_Cop)
    I tried looking up tutorials online but I don't really get the explanations so could some one help explain solve this question. It's from the ICT level 2 2016 june paper . The question is: Use a lookup function and the information in cells I5 to J8 to enter the Re-order Level for each product. I have a table with product types, product names, description of the product, opening stock, stock sold, Remaining stock and an empty coloumn for the Re-order level. There is also cells I5 and J8 which is a smaller refrence table with product types and some re-order levels.
    A screenshot of the info would help, as well as what specifically you are stuck with as it tells you what to do...

    And advice for solving computer problems, do it on paper in words first. What is re-order level, where is the info and how will you use the lookup function to get it?
    • Very Important Poster
    • PS Reviewer
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    Very Important Poster
    PS Reviewer
    Clearing and Applications Advisor
    (Original post by Sophie_Cop)
    I tried looking up tutorials online but I don't really get the explanations so could some one help explain solve this question. It's from the ICT level 2 2016 june paper . The question is: Use a lookup function and the information in cells I5 to J8 to enter the Re-order Level for each product. I have a table with product types, product names, description of the product, opening stock, stock sold, Remaining stock and an empty coloumn for the Re-order level. There is also cells I5 and J8 which is a smaller refrence table with product types and some re-order levels.
    You need to use the vlookup function to add in the reorder level from the I5:J8 table into the "Reorder level" empty column.

    something like
    =vlookup(A2,$I$5J$8,2,0) [assuming that you enter this into row 2 and A2 contains the product type for that row]

    - that roughly breaks down as =vlookup(the product type for the row, reference table with product type in the first column, column in the reference table to bring the value from, only add exact matches for product type)
    • Thread Starter
    Offline

    2
    ReputationRep:
    Thanks this worked.
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: February 8, 2018
The home of Results and Clearing

3,177

people online now

1,567,000

students helped last year

University open days

  1. SAE Institute
    Animation, Audio, Film, Games, Music, Business, Web Further education
    Thu, 16 Aug '18
  2. Bournemouth University
    Clearing Open Day Undergraduate
    Fri, 17 Aug '18
  3. University of Bolton
    Undergraduate Open Day Undergraduate
    Fri, 17 Aug '18
Poll
Will you be tempted to trade up and get out of your firm offer on results day?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.