Every time some data migration activity comes up, We just go on sending mail to technical guys.
Every thing is there in data base and we have functional data. We need to match up data and give it to process to tech guys.
V look up comes handy when u have 2 set of data tables and u need to match the value of 1 column value to other set of data and retrieve information from 3rd column correspondingly.
Following You tube vdo is very much handy to learn the process and apply the V Look up feature in Excell.
Here is the link
Excel 2007 Tutorial VLOOKUP
No comments:
Post a Comment