[Root-guide] VLookup Function in MS Excel with Appropriate Match

Sedikit Info Seputar [Root-guide] VLookup Function in MS Excel with Appropriate Match Terbaru 2017 - Hay gaes kali ini team Info Fresh, kali ini akan membahas artikel dengan judul [Root-guide] VLookup Function in MS Excel with Appropriate Match, kami selaku Team Info Fresh telah mempersiapkan artikel ini untuk sobat sobat yang menyukai Info Fresh. semoga isi postingan tentang Artikel android, Artikel Root-guide, Artikel Samsung-Galaxy, yang saya posting kali ini dapat dipahami dengan mudah serta memberi manfa'at bagi kalian semua, walaupun tidak sempurna setidaknya artikel kami memberi sedikit informasi kepada kalian semua. ok langsung simak aja sob
Judul: Berbagi Info Seputar [Root-guide] VLookup Function in MS Excel with Appropriate Match Terbaru
link: [Root-guide] VLookup Function in MS Excel with Appropriate Match

Berbagi [Root-guide] VLookup Function in MS Excel with Appropriate Match Terbaru dan Terlengkap 2017

cj7blog.blogspot.com - Hi, everyone today we discuss another very important topic which you face when you go for interview during the doing job in any company or facing the questions about “VLookup” during the interview session. You know very well “VLookup” is one of the most important functions which are found in “Lookup and Reference” category of Microsoft Excel. There are lot of different examples of VLookup function in Excel, which you can use in different situation.

When we are using “VLookup” function, most of the cases we use “Exact Match” method in MS Excel. Today I try to tell you how to use VLookup function with “Appropriate Match” in range lookup. VLookup: This function is found in the “Lookup and Reference” categories of Microsoft Excel So have a look and take few easily use appropriate match in range lookup:

Syntax of VLookup:

The Microsoft Excel VLookup function searches a value in the extreme left column of the table_array and provides the value in the same row which is based on the index number.

= VLookup (lookup_value, table_array, col_index_num, [range])

Note: Before using the VLookup function, first you need to arrange first column of a table or array in the ascending order, otherwise VLookup function is not able to provide the accurate result.

Lookup_value: The value to be searched in the extreme first column of the table array.

Table_array: Two or more columns of data. Give cell reference of a range / range name.

Col_index_num: The column index_number in the table from which the searched value must be returned.

If col_index_num of returns 1 the value in the first column in table_array.

If col_index_num is: Less than 1, this function returns an error value the #VALUE!.

If it is a greater than the number of columns in table_array, this function returns error value #REF!.

Range_lookup: It is an options part of this function. There are two options available in this part.

TRUE: Appropriate Match: This option work properly when first column of your table will be sorted in ascending order only otherwise it displays wrong result.

False: Exact Match: VLookup by default check only on exact match method.

For example, Have a look and find what the main difference when you use “Appropriate Match” option during applying VLookup formula in any sorted and unsorted table.

Step 1: Create the following table

Step 2: Select and copy the range A1:D6 and paste it on F1:I6.

Step 3: Select the range A1:D6 and set the name “Unsorted table” from name box.

Step 4: Select the range F1:I6 and click Home tab > Click “Sort and Filter” option in Editing group > Click Sort A to Z. You can also click Data tab > Click “Sort A to Z” button. Click on the name box and set the name “Sorted Table”.

Step 5: If you want to view the result on unsorted table apply the following given formula on cell B10: =VLOOKUP(B9,A2:D6,2,1). When you press enter, Microsoft Excel displays “Banana” as a result.

Step 6: If you want to view the result on sorted table apply the following given formula on cell G10: = =VLOOKUP(G9,F2:I6,2,1). When you press enter, Microsoft Excel displays “Mango” as a result.

So, this is the main difference when you apply formula on unsorted table Microsoft Excel display “Banana” while you apply this formula on sorted table Microsoft Excel displays “Mango” as a result.

I hope you like this article, if you have any query then type your question regarding this post in the comment box. Thanks.

source : http://pinterest.com, http://fb.com

Itulah sedikit Artikel [Root-guide] VLookup Function in MS Excel with Appropriate Match terbaru dari kami

Semoga artikel [Root-guide] VLookup Function in MS Excel with Appropriate Match yang saya posting kali ini, bisa memberi informasi untuk anda semua yang menyukai Info Fresh. jangan lupa baca juga artikel-artikel lain dari kami.

Terima kasih Anda baru saja membaca [Root-guide] VLookup Function in MS Excel with Appropriate Match