Named ranges don't work with VLOOKUP

[scottgifford]

A spreadsheet I am working with has a named range items for a grid of cells, and then uses that named range in a VLOOKUP, like this:

VLOOKUP(A1,items,2,FALSE)

When I evaluate this formula it returns #VALUE!.

It works correctly in Excel, and also in formulas.

If I replace the named range with a cell range it works fine:

=VLOOKUP(A1,VDATA!A1:B100,2,FALSE)

Would you expect this to work in xcalculator? And if so would a minimal test case be helpful?

Thanks!

----Scott.