Week 5 - Seminar

During today's seminar we were practising use of Lookup and VLookup function. This feature of Excel was completely new to me, however I knew there must be a way how to make browsing through lengthy lists of items and values. We started creating a table with a list of items (types of shoes) with 4 columns of which the first one identifies item by number, the second is the item.s name and then 2 columns with values. We tried using few different combinations of looking up an item by an item number (ID), matching the existing ones or different from any item numbers. We tried looking up the item by the name, the difference is just in choosing the right column as in "data to search" and the "results column". I would say this function is straight forward and now I am confident using it even in different potential cases. The LOOKUP formulas used during exercise are located on the right of the screenshot.

 After the Lookup function we were learning how to apply VLookup function. It is the same principle, however this one is used to look up first column (ID or item number) of the table for a value. We tried different variations and also use of True/false in the formula. I am now familiar with the function and will keep it in mind when working on our course work when creating spreadsheet as a list of products /stock sheet as a solution for the company in order to have better stock control. The VLookup formulas are in the screenshot highlighted in yellow. First screenshot shows default view of the spreadsheet and the second shows formulas used.