Just a guess - do the range names use absolute cell references? If not,
that's likely your problem - change them to absolute references

"Ann Scharpf" wrote:

I have a user with a three sheet workbook. There are two named ranges (on
sheets 2 & 3) which are used in vlookup functions on sheet 1. The VLOOKUP
works fine in the first 12 rows of sheet 1. On row 13, it keeps returning
the error A VALUE IS NOT AVAILABLE TO THE FORMULA OR FUNCTION. Here are the
formulas:

=VLOOKUP(D26,dfcc,2,FALSE)
=VLOOKUP(D27,uscc,2,FALSE)

I can copy the cell with the error result and paste it in a cell in rows 1 -
12. Works fine. I can enter a successful lookup value from the first 12
rows in column d anywhere below row 13 and it fails.

I have never seen anything like this and don't have a clue how to fix it.
Can anyone give me an idea? Thanks very much for your insight.

--
Ann Scharpf