Microsoft Excel:-I want to get the information from different excel file.(VLOOKUP formula).?

Question

I know how to use VLOOKUP formula for getting information in the same file.But I need to use the VLOOKUP formula to get the information from different file.Let me know if you have any information.Thank you.

Answer 1

All you have to do is include the filename and worksheet name in the formula as shown here:

=VLOOKUP(A3,[FILENAME.xls]Sheet1!$A$1:$B$9,2)

The external Workbook with the data does not have to be open for the vlookup function to work.

EDIT: If Yahoo cuts off the end of the formula, just hover your mouse over it to see the whole thing.

Answer 2

Im uncertain how your archives is desperate up. Assuming that the time is in distinctive cells, you elect the version of the two cells in one column/cellular, yet whilst the "time try" is fake, then the version will bypass to a distinctive column/cellular. 7 AM=seven hundred. 7 PM=1900. you would be wanting 2 formulation in 2 distinctive column/cells. Use the , IF(AND( assertion. =IF(AND(Time A<=seven hundred,Time B=>1900, Time B - Time A, "")) This formulation will place the time distinction in one cellular and if the checks are fake it places a void in that cellular, (""). the 2d formulation would look like this, in a distinctive cellular. =IF(AND(Time A=>seven hundred, Time B<=1900, Time B - Time A, "")) those try that the time is equivalent and extra suitable than or decrease than. in case you elect the attempt to easily be real whilst the time is far less or extra, then delete the equivalent sign. i'm no longer particular that this is what you elect, however the IF AND assertion is mandatory.

Answer 3

you link to this file. to do this, open both files, select the info you are wanting to copy. go to the new file and right-click, do a paste special. you will see the options listed here. check the selection you are looking for

when you update the first spreadsheet, the second one will auto update as well

good luck