In addition to the above, also please check the following link: http://chandoo.org/excel-formulas/vlookup.html
<http://chandoo.org/excel-formulas/vlookup.html>Thnx Vinod N On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > Hi, > > > Adding to this................... this PPT Gives good understanding > regarding > Vlookup hope this helps you.......... > > > Attached is the PPT presentation regarding the vlookup ..... > > In case of any queries just let me know................ > > Regards, > Raj > > > > On Thu, Aug 26, 2010 at 11:18 PM, Kal xcel <kalx...@gmail.com> wrote: > >> Hi Pankaj, >> >> Vlookup means Vertical lookup that is find the given value in vartical >> order. vlookup is the way to find the particular data from master file. It >> gives the data in vertical manner from the right side of the column >> against which data has to find. >> >> Syntax >> >> VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) >> >> Lookup_value The value to search in the first column of the table array >> (array: Used to build single formulas that produce multiple results or >> that >> operate on a group of arguments that are arranged in rows and columns. An >> array range shares a common formula; an array constant is a group of >> constants used as an argument.). Lookup_value can be a value or a >> reference. >> >> Important: If lookup_value is smaller than the smallest value in the first >> >> column of table_array, VLOOKUP returns the #N/A error value. >> >> Table_array Two or more columns of data. Use a reference to a range or a >> range name. The values in the first column of table_array are the values >> searched by lookup_value. These values can be text, numbers, or logical >> values. >> >> Note: Uppercase and lowercase text are equivalent. >> >> Col_index_num The column number in table_array from which the matching >> value must be returned. A col_index_num of 1 returns the value in the >> first >> column in table_array; a col_index_num of 2 returns the value in the >> second >> column in table_array, and so on. If col_index_num is: >> >> Less than 1, VLOOKUP returns the #VALUE! error value. >> Greater than the number of columns in table_array, VLOOKUP returns the >> #REF! >> error value. >> >> Range_lookup A logical value that specifies whether you want VLOOKUP to >> find an exact match or an approximate match: >> >> If TRUE or omitted, an exact or approximate match is returned. If an exact >> >> match is not found, the next largest value that is less than lookup_value >> is >> returned. >> >> The values in the first column of table_array must be placed in ascending >> sort order; otherwise, VLOOKUP may not give the correct value. You can put >> >> the values in ascending order by choosing the Sort command from the Data >> menu >> and selecting Ascending. For more information, see Default sort orders. >> >> If FALSE, VLOOKUP will only find an exact match. In this case, the values >> in >> the first column of table_array do not need to be sorted. If there are two >> or >> more values in the first column of table_array that match the >> lookup_value, >> the first value found is used. If an exact match is not found, the error >> value #N/A is returned. >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe