Ask Your Question

how do you use vlookup between different work book

asked 2015-01-16 03:29:09 +0200

Mahantesh Patil gravatar image

updated 2015-01-16 03:31:13 +0200

I am using version on Windows 7 OS. I am able to use vlookup function within the same worksheet / work book / file. How do I use between 2 different files. I am not able to select the array as it is not getting highlighted.

Please suggest.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-01-16 23:00:41 +0200

LogicDaemon gravatar image

updated 2015-01-16 23:01:12 +0200

Instead of actually referencing different file (though this is also possible via DDE link, I don't recommend), insert some sheets from file you're referencing, Link'ing them (it's checkbox in sheet insert dialogue).

When opening this spreadsheet, LO will ask to refresh or not imported sheet(s). You're able to edit references (or break link, keeping contents) via Edit → Links.

This is very similar to what Excel does when referencing another spreadsheet in formulae (Excel actually saves referenced ranges to spreadsheet, but doesn't show them anywhere).

edit flag offensive delete link more

answered 2015-01-16 12:59:56 +0200

Lupp gravatar image

Did you try to reference into a newly created, not yet saved file? This is impossible because an external reference must contain a document (file) location.

If this was your situation the remedy is saving any source file first. If not, please give us more details.

edit flag offensive delete link more


Thanks for the solution. I saved the file & it is solved...

Mahantesh Patil gravatar imageMahantesh Patil ( 2015-01-19 08:48:39 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-16 03:29:09 +0200

Seen: 1,405 times

Last updated: Jan 16 '15