In Excel, if you have two different .xlsx file and just 1 common information in these files, you can use VLOOKUP command to match&pull datas and combine them...
For example you can use if you have same columns included citizenship number, customer number, telephone number etc.
Formula Example:
Include into C2 cell this formula without quotas: "=VLOOKUP(B2:B6;[A.xlsx]Sheet1!$A$2:$E$6;4;0)"
Include into D2 cell this formula without quotas: "=VLOOKUP(B2:B6;[A.xlsx]Sheet1!$A$2:$E$6;5;0)"
A tip from the Microsoft's website:
In its simplest form, the VLOOKUP function says:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Note: VLOOKUP searches left to right. If you want to search top to bottom, you can use HLOOKUP command.
Here are the sample files:
A.xlsx
B.xlsx
Formula Example:
Include into C2 cell this formula without quotas: "=VLOOKUP(B2:B6;[A.xlsx]Sheet1!$A$2:$E$6;4;0)"
Include into D2 cell this formula without quotas: "=VLOOKUP(B2:B6;[A.xlsx]Sheet1!$A$2:$E$6;5;0)"
A tip from the Microsoft's website:
In its simplest form, the VLOOKUP function says:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Note: VLOOKUP searches left to right. If you want to search top to bottom, you can use HLOOKUP command.
Here are the sample files:
A.xlsx
B.xlsx
Comments
Post a Comment