Can't figure out what this column was intended for?!
data.XLSX>pizzas spreadsheet>column E
https://imgur.com/OsOdqCe
[Dropped] =VLOOKUP(A36,#REF!,1,0) ERROR
[Dropped] =VLOOKUP(A36,#REF!,1,0) ERROR
Last edited by MrProgrammer on Mon Apr 15, 2024 8:51 pm, edited 1 time in total.
Reason: Dropped: No attachment provided to demonstrate the problem -- MrProgrammer, forum moderator
Reason: Dropped: No attachment provided to demonstrate the problem -- MrProgrammer, forum moderator
OpenOffice 3.1 on Windows Vista
Re: =VLOOKUP(A36,#REF!,1,0) ERROR
There is no obvious use for that formula. Besides the broken reference, it is set to return the first column in the reference table, which would just be the value of column A.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: =VLOOKUP(A36,#REF!,1,0) ERROR
Use semicolons instead of commas to separate parameters.
AOO 4.1.15 & LO 24.2.2 on Windows 10
Re: =VLOOKUP(A36,#REF!,1,0) ERROR
Typical causes of that #REF! error within a formula:
- You have copied a formula with a relative reference from an other spreadsheet cell, and when you paste it, that relative reference would point to an invalid cell coordinate (left of column A or above row 1)
- The lookup range columns (or in some cases, the rows) have been deleted.