Example formulae for vlookup is
=VLOOKUP(D4,'[OtherExcelFile.xlsx]OtherExcelFileSheetName'!$H$112:$I$120,2,TRUE)
here
D2 is column I am finding
H112 to H120 is records to search in
I112 to I120 is record rows which I have to bring.
2 is column I am referring to i.e I column here.
You can use match which is more easy than Vlookup for this task.
=VLOOKUP(D4,'[OtherExcelFile.xlsx]OtherExcelFileSheetName'!$H$112:$I$120,2,TRUE)
here
D2 is column I am finding
H112 to H120 is records to search in
I112 to I120 is record rows which I have to bring.
2 is column I am referring to i.e I column here.
You can use match which is more easy than Vlookup for this task.
No comments:
Post a Comment