[Solved] #name? error

[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.

[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.

[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

[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!!!!