[Solved] Err:508 from VLOOKUP

[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

[MrProgrammer]

Hi, and welcome to the forum. Thank you for the attachment.

I am receiving Err 508 message

[Solved] … get Err:508

I'm new to OpenOffice …

Read section 9. Using functions and cell ranges in Ten concepts that every Calc user should know.

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

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

[RickMcc]

Thank you very much! I will defiantly review the info you provided.

[MrProgrammer]

I will defiantly review the info you provided.

XKCD: Definitely

Definitely.gif (81.29 KiB) Viewed 3307 times

[RickMcc]

Point taken, I did not check my spelling