Page 1 of 1

[Solved] #name? error

Posted: Thu Feb 14, 2013 2:59 am
by Darth Yoda
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.

Re: #name? error

Posted: Thu Feb 14, 2013 3:26 am
by joe theengineer
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.

Re: #name? error

Posted: Thu Feb 14, 2013 3:28 am
by thinman3
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

Re: #name? error

Posted: Fri Feb 15, 2013 3:45 am
by Darth Yoda
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!!!!