RE: VLOOKUP
Wayne
when you want to lookup data in one cell that is stored as part of a list in another area,
The syntax for the VLookup function is:
=VLookup( value, datalist, index_number, not_exact_match )
value is the value to search for in the first column of the datalist.
datalist is two or more columns of data that is sorted in ascending order.
index_number is the column number in datalist from which the matching value must be returned. The first column is 1, not A, and you can only start from left first column
not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.
If index_number is less than 1, the VLookup function will return #VALUE!.
If index_number is greater than the number of columns in table_array, the VLookup function will return #REF!.
If you enter FALSE for the not_exact_match parameter and no exact match is found, then the VLookup function will return #N/A.
hope this answers your question
david
