For this formula to work as is, Track must be a named range which includes
cells in at least two adjacent columns. One of the cells in the leftmost
column of Track must have the value contained in A3 on the sheet which has
the Vlookup formula.

If it is returning the word "No", instead of a #VALUE or #N/A error, then it
is working. If the value in A3 is found more than once in the Track range,
the first exact match will be used by Vlookup.

Hope this helps,

Hutch

"PAL" wrote:

I am using this formula: =VLOOKUP(A3,Track,2,FALSE).

It is returning a "No" value, which is not correct ideas?