Vlookup

[PAL]

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

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

 

[ryguy7272]

From Excel's help:
VLOOKUP(lookup_value,table_array,col_index_num,range_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---

 

[Tom Hutchins]

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