[Solved] Err:508 in Excel lookup formula

[BulletBS]

Good Morning, I am needing help with a formula please. I have attached my example file. I want to put the latest total stock values of each stock on page 1 of the work book. Need to first find the latest date in column A, then take the total stock value from each page (Column D) and put it in the aligning stock column on page 1 (Row 2). I have tried vlookup, and index with no results (see "Totals" sheet cells A4:A5 ) . I can find the latest date using the Max command but that is where I am stuck. Any help is appreciated.

[MrProgrammer]

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

Need to first find the latest date in column A, then take the total stock value from each page (Column D) and put it in the aligning stock column on page 1 (Row 2).

Your Excel syntax for sheet Stock1 is incorrect for Calc. Use Calc syntax to reference that sheet. Use semicolons in OpenOffice.

=VLOOKUP(MAX('Stock1'!A2:A40),'Stock1'!A2:D40,4,0)      should be
=VLOOKUP(MAX(Stock1.A2:A40);Stock1.A2:D40;4;0)

[Tutorial] VLOOKUP questions and answers
[Tutorial] Calc formula terms
[Tutorial] Ten concepts that every Calc user should know

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.

[BulletBS]

Mr. Programmer, thank you kind sir for your assistance!!