Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
I am using this formula: =VLOOKUP(A3,Track,2,FALSE).
It is returning a "No" value, which is not correct ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |