As we know how to use Vlookup in Windows OS. Vlookup in Linux is somewhat different than the traditional method.
Generally, in windows we can apply vlookup method for file in any location of the Computer System. But in Linux, we need to copy the data of the excel sheet from where we need to use the data. Lets see an Example.
Step 1: We have added 3 Columns namely Id, First Name & Last Name to Sheet 2,
The column "Country" is blank, as we would be importing this information from Sheet 3 of the same File.
Step 2: The most important thing is to copy the data from the other file and paste it to the sheet 3 of our file where we want to use it. There should be a common column, here the common column is "Id".
Step 3: Now, we select the Sheet 3 & name the sheet as "hello" and press "ENTER". And make sure that the sheet has got the name by re-selecting the Sheet.
Step 4: Now, in Cell D2 of Sheet 2. We write the formula for vlookup to import the data of Country Column from Sheet 3.
=vlookup(A2, hello, 4, 0)
Here A2 is a column with common values.
"hello" is the name of Sheet 3
"4" is the Column number 4 from Sheet 3 i.e "Country".
0 means Exact match.
Step 5: Now drag down the formula for all the rows. You get the required data from Sheet 3.
How to Remove Duplicate Rows in Excel
removeduplicaterowsinexcel.blogspot.in
Generally, in windows we can apply vlookup method for file in any location of the Computer System. But in Linux, we need to copy the data of the excel sheet from where we need to use the data. Lets see an Example.
Step 1: We have added 3 Columns namely Id, First Name & Last Name to Sheet 2,
The column "Country" is blank, as we would be importing this information from Sheet 3 of the same File.
Step 2: The most important thing is to copy the data from the other file and paste it to the sheet 3 of our file where we want to use it. There should be a common column, here the common column is "Id".
Step 3: Now, we select the Sheet 3 & name the sheet as "hello" and press "ENTER". And make sure that the sheet has got the name by re-selecting the Sheet.
=vlookup(A2, hello, 4, 0)
Here A2 is a column with common values.
"hello" is the name of Sheet 3
"4" is the Column number 4 from Sheet 3 i.e "Country".
0 means Exact match.
Step 6: We now need to remove the formula from the cells. We copy the imported data and RIGHT CLICK. You see option as Paste Special, In that you need to select the option "123", as shown in figure.
Step 7: You get the required Solution.
Thanks for reading the blog!!!
Other Related Post:How to Remove Duplicate Rows in Excel
removeduplicaterowsinexcel.blogspot.in
No comments:
Post a Comment