{"id":1461,"date":"2012-09-23t08:25:31","date_gmt":"2012-09-23t12:25:31","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=1461"},"modified":"2019-10-09t14:37:12","modified_gmt":"2019-10-09t18:37:12","slug":"excel-vlookup-tutorial-for-p6-users","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/excel-vlookup-tutorial-for-p6-users\/","title":{"rendered":"excel vlookup tutorial – step by step for primavera p6 users"},"content":{"rendered":"

primavera users are also excel users. \u00a0as many of you know, microsoft excel<\/a> has many useful functions in different areas such as financial, date & time, math & trig and so on. one of these areas is look up & reference. the functions in this area are dealt with lists, indexes and arrays and help us to find some special information in these listed data or other. this required information could be address of a desired cell which contains some special value, a value or action to perform a list of values, a reference specified by a text string, a relative position of an item in array that matches a specified value in a specific order and finally: a value in the leftmost column of a table and then returns a value in the same row from a column you specify.<\/p>\n

the last function is called vlookup and i myself find it very useful in most of the planning activities. sometimes when you have some spreadsheets with heaps of information in them and you need to transfer some updated information from one list into another, vlookup helps you to do it fast and accurate. this list could be your export from primavera and you can update it from a database (which most of the time can have an output in the form of a spreadsheet) using vlookup and then import it in primavera and everything is updated now, easy and quick! let\u2019s see how can we define and use this function in our excel vlookup tutorial.<\/p>\n

\n

how to write a vlookup formula<\/h2>\n

let’s start with a practical example. suppose that we have a list of updated progress of some documents and we want to update their percent completes<\/a> in another list which has been exported from primavera. here are our lists:.<\/p>\n

\"excel<\/div>\n

let\u2019s call the right table database table and the left one primavera table. now we want to have percent complete for each document. so we start writing the formula in the activity % complete column in primavera table.<\/p>\n

\"excel<\/div>\n

when you choose vlookup function in excel, you should complete the following inputs:<\/p>\n