Why does this give me an error?
=ifd4+C3>D3:VLOOKUP(B2;'Odd tables'.P3:Q33:2;0)
Odd tables is referenced many times but seems to fail here.
[Solved] #name? error
-
- Posts: 8
- Joined: Tue Feb 12, 2013 3:15 am
[Solved] #name? error
Last edited by Hagar Delest on Fri Feb 15, 2013 11:48 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice3.1.1
Windows XP
Windows XP
-
- Posts: 6
- Joined: Wed Feb 13, 2013 8:23 pm
Re: #name? error
Maybe a name that is used has not been defined, or has lost its definition.
....... Select the range of the variable, then go to..... insert name define ......
Put the new name on top, check that the range is correct at the bottom
..... push add and OK.
....... Select the range of the variable, then go to..... insert name define ......
Put the new name on top, check that the range is correct at the bottom
..... push add and OK.
OpenOffice 3.4.1 on Windows 7
Re: #name? error
Most likely cause would be that the formula, as presented, is unworkable due to structure errors.
=ifd4+C3>D3:VLOOKUP(B2;'Odd tables'.P3:Q33:2;0) should look like the following:
=IF((D4+C3)>D3;VLOOKUP(B2;Oddtables.P3:Q33;2;0);"") OR =IF((D4+C3)>D3;VLOOKUP(B2;oddtables.P3:Q33;2;0))
thinman3
=ifd4+C3>D3:VLOOKUP(B2;'Odd tables'.P3:Q33:2;0) should look like the following:
=IF((D4+C3)>D3;VLOOKUP(B2;Oddtables.P3:Q33;2;0);"") OR =IF((D4+C3)>D3;VLOOKUP(B2;oddtables.P3:Q33;2;0))
thinman3
3.4.1 & 4.1.5 on MS Windows 7 Pro x64
-
- Posts: 8
- Joined: Tue Feb 12, 2013 3:15 am
Re: #name? error
Thank you Thinman3. This expression:
=IF((D4+C3)>D3;VLOOKUP(B2;Oddtables.P3:Q33;2;0);"")
got me started again. I got a #ref so I had to reselect the oddtable range though. Easy fix.
Two Stars!!!!
=IF((D4+C3)>D3;VLOOKUP(B2;Oddtables.P3:Q33;2;0);"")
got me started again. I got a #ref so I had to reselect the oddtable range though. Easy fix.
Two Stars!!!!
OpenOffice3.1.1
Windows XP
Windows XP