G
Guest
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.
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.