Re: [libreoffice-users] Help please with lookup from another sheet.

At 17:16 01/02/2017 +0000, Budge Noname wrote:
> ... when created each sheet is in a different file. I have imported 
> on into the other to get them in the same file but the sheet tab 
> names are the filenames not "sheet 1" or "sheet 2." Do I have to 
> type in the full filename? In parenthesis?

Wasn't this covered early in your "Introduction to Spreadsheets" 
course? Or in the first chapter of your "Spreadsheets for Beginners" book?

To get
=VLOOKUP(A1;Sheet2.$A$1:$B$10;2;0)
in B1:
o Click in B1.
o Type "=VLOOKUP(".
o Click on A1.
o Type ";".
o Click on the sheet tab to reveal the other sheet (whatever it may 
be called and wherever it is).
o Drag over A1 to B10 on that sheet.
o Type ";2;0)".
o Press Enter or click the green tick in the Input Line.

You may want to click the sheet tab to return to your first sheet at 
some point in that process, but it is not necessary.

> On the [Windows] machine, tab doesn't complete the typing so it is a 
> bit of a pain.

That because Windows users don't type: they gave that up with DOS, 
some time in the last millennium. You ought to try it.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted