How to use Vlookup function in sheet 1 to sheet 2

Hi Friends,
Today we will learn how to use Vlookup function in MS-Excel.

What is vlookup function and how to use.

Vlookup: Vlookup is look and identify the value from table and select the range of array from another matchback table and select the column no those you want and check the value of True for approximate or false for an exact match.

=Vlookup(lookup_value,table_array,column_index_num,[range_lookup])
1.  lookup_value:-->lookup value
2.  table_array :--> range containing the lookup value
3.  column_index_num:--> The column number in the range containing the return value
4.: [range_lookup]:--> Optionally specify TRUE for approximate match or FALSE for                      an exact match

Visit and subscribe My YouTube Channel and Blog Home page
Youtube Channel

Blog Home Page

How to create facebook account

Hi Friends

Today we will learn how to create Facebook account.See complete video and get full information.

1. Search in google Facebook Signup or Go to www.facebook.com
2. Fill personal information
3. Click on create button.
Now your Facebook account has been created.
See continue how to do live in this video.

How to send email from Gmail account

Hi Friends

Today we will learn How to send email from Gmail account.

Five Steps always remember in your mind.
1. To: Recipients email id
2. Subject line
3. Topics of containt
4. Signatures
5. Click on send button
 Now we will see live in gmail account. How to send email from Gmail account.

pls see full videos and click below on subscribe red button now.