[libreoffice-users] Looking up and entering from table on another sheet.

Struggling here with VLOOKUP which I think is the right tool.

I have a column of numbers on one sheet (sheet 1) and on another sheet 
(sheet 2) a column of numbers with an associated name in adjacent cell. 
My objective is to find the name associated with the number on sheet 2 
and enter it in sheet 1, or put another way: to take (in turn down the 
column) the number on sheet 1, find this number in the column in sheet 2 
and write the name adjacent to that number in cell adjacent to the 
number I started with in sheet 1.

The numbers are random and not necessarily to be found in second sheet. 
If no name is found I need some marker entered so I know I must
recourse to a manual search elsewhere.

I think VLOOKUP might be the right tool but got stuck right at the start 
trying to reference across two sheets.  I have both open in same 
instance of LibreOffice.

Please could somebody confirm my approach and or advise how to proceed.

--
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