Syntax error in VLOOKUP formula for another spreadsheet
VLOOKUP(A2,Obaveze :: Budget :: $A$2:$C$31,3,0)
i have got syntax error
[Re-Titled by Moderator]
Original Title: Vlookup from another speedsheet
iPhone SE, iOS 18
Question marked as
It's not clear what that data represents, but from the subject of your post it sounds like you're trying to VLOOKUP() a value from a different spreadsheet. Is that the case?
If so, know that Numbers does not support cross-document linking. It's something that Excel does, so if the original spreadsheets are coming from Excel, that may explain why they're written that way, but Numbers will only reference tables within the same document.
You can combine the various Excel documents into separate tabs within Numbers -that way you still have a degree of separation, and Numbers can reference the other tabs.
