Vlookup
 

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

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

Vlookup
 

From Excel's help:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

Which argument doesn't look right? It may have something to do with
Ascending/Descending order of your data.

Look here for an alternative to Vlookup:
http://www.contextures.com/xlFunctions03.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"PAL" wrote:

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

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

Vlookup
 

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?