This is the syntax of Vlookup .... in your formula 2 is the nth column in Range .... If you will not False in the formula then it will return you closest match and will not return any error ......
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string.
Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.
If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.
You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.
The values in the first column of table_array can be text, numbers, or logical values.
Uppercase and lowercase text are equivalent.
a2 817
a3 525
a4 635
a5 254
a6 852
a7 969
a8 857
a9 568
a10 963
a11 254
when I put a9 in column A1 , COLUMN D1 should return the value 568, when I put a5 in colum A1, then column Di should return the value 254, like that...can u assist ?
A B C D
1 1 Z Z
1 2 Y Z
1 3 X Z
1 4 W Z
2 5 V Y
2 6 U Y
2 7 T Y
3 8 S X
3 9 R X