Page 1 of 1
[Solved] Err:508 from VLOOKUP
Posted: Wed Dec 11, 2024 5:22 pm
by RickMcc
Hi there,
I'm new to OpenOffice and this the first time using VLOOKUP
I am receiving Err 508 message
My formula is =vlookup(B6,Sheet3,A2:B103,2,0)
Attached is the character sheet for a game I am working on.
Any help would be greatly appreciated. Thank you.
Rick
Re: Need help with VLOOkUP
Posted: Wed Dec 11, 2024 6:31 pm
by MrProgrammer
Hi, and welcome to the forum. Thank you for the attachment.
RickMcc wrote: ↑Wed Dec 11, 2024 5:22 pm
I am receiving Err 508 message
[Solved] … get Err:508
RickMcc wrote: ↑Wed Dec 11, 2024 5:22 pm
I'm new to OpenOffice …
Read section
9. Using functions and cell ranges in
Ten concepts that every Calc user should know.
RickMcc wrote: ↑Wed Dec 11, 2024 5:22 pm
My formula is =vlookup(B6,Sheet3,A2:B103,2,0)
That is not a valid formula for OpenOffice Calc. Perhaps you want
=VLOOKUP(B6;$Sheet3.$A$2:$B$103;2;0) (note use of period, dollar sign, and semicolon).
RickMcc wrote: ↑Wed Dec 11, 2024 5:22 pm
… first time using VLOOKUP
[Tutorial] VLOOKUP questions and answers
If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
Re: Err:508 from VLOOKUP
Posted: Wed Dec 11, 2024 10:04 pm
by RickMcc
Thank you very much! I will defiantly review the info you provided.
Re: [Solved] Err:508 from VLOOKUP
Posted: Thu Dec 12, 2024 8:50 pm
by MrProgrammer
RickMcc wrote: ↑Wed Dec 11, 2024 10:04 pm
I will defiantly review the info you provided.
XKCD: Definitely
- Definitely.gif (81.29 KiB) Viewed 3306 times
Re: [Solved] Err:508 from VLOOKUP
Posted: Thu Dec 12, 2024 9:10 pm
by RickMcc
Point taken, I did not check my spelling