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

On 04/10/2018 10:24, Budge wrote:
> 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

I think I have solved my automatic quotes repeat but still have the 
VLOOKUP question please.

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