You are Here: Home

# Using LOOKUP watch

1. 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.
2. (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?
3. (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)
4. Thanks this worked.

### Related university courses

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: February 8, 2018
The home of Results and Clearing

### 3,177

people online now

### 1,567,000

students helped last year
Today on TSR

Hang on, have Edexcel's come out already?

### University open days

1. SAE Institute
Animation, Audio, Film, Games, Music, Business, Web Further education
Thu, 16 Aug '18
2. Bournemouth University
Fri, 17 Aug '18
3. University of Bolton
Fri, 17 Aug '18
Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

## Groups associated with this forum:

View associated groups

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