[libreoffice-users] Help with VLOOKUP across 2 sheets please.

I cannot sort out my vlookup when looking up in another sheet and 
entering in first sheet. I was hoping to ask for help but now I can't 
even highlight my entry and right click to copy and paste here.  As soon 
as I highlight line it goes black and will not right click.

Also I cannot get single quote to work even though as you advised a 
while ago I have Tools Autocorrect Options > Localized Options turned off
Am I losing my grip?

I shall type in what I have now:-

=VLOOKUP(A2,$Sheet1.$A$2:$B$1276,2,0)

I am seeking to find the value in A2 in first sheet from an array in 
"sheet1" (the second sheet) column A and enter the result in the entry 
column in the first sheet.  I think there should be single quotes around 
Sheet1 which is the label of sheet 2 but I cannot get them to save!!!

Grateful for any help when you have time please.

---
This email has been checked for viruses by AVG.
https://www.avg.com


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy