Hi i have somedata that looks like this:

TrackerID Date Time Day Northing_Y Easting_X Speed_kmh
102 7/2/2004 23:00:27 Friday 3.133891782 101.6948749 50
102 7/2/2004 23:00:34 Friday 3.133070734 101.6943788 53
102 7/2/2004 23:00:41 Friday 3.132447929 101.6935176 64
102 7/2/2004 23:00:47 Friday 3.132242237 101.6924949 64
102 7/2/2004 23:00:54 Friday 3.131492808 101.6917019 61
102 7/2/2004 23:01:00 Friday 3.130511904 101.691408 68
102 7/2/2004 23:01:06 Friday 3.129463391 101.6911232 71
102 7/2/2004 23:01:12 Friday 3.12857015 101.690505 71
102 7/2/2004 23:01:18 Friday 3.127903227 101.6895991 71
102 7/2/2004 23:01:24 Friday 3.127185884 101.6887128 75
102 7/2/2004 23:01:30 Friday 3.126517815 101.6877932 71
102 7/2/2004 23:01:36 Friday 3.126013613 101.6867848 75

if the value of Northing_Y AND/OR Easting_X of any row matched the
criteria of the following table, that row is said to be belong to that
criteria and an ID of that criteria should be assign next to that row.

Criteria yLB yUB xLB xUB
*1 =3.137263 <3.138149
2 =3.136371 <3.137263
3 =3.135472 <3.136371
4 =3.134575 <3.135472
5 =3.133716 <3.134575
6 =3.13297 <3.133716
*7 <=3.13297 =101.693463
8 =101.692597 <101.693463
9 =3.131821 <101.692597
10 =3.13099 <3.131821
11 =3.130125 <3.13099
12 =3.129286 <3.130125

For example if a row's Northing_Y is =3.137263 AND <3.138149, then
it's ID is 1
If a row's Northing_Y is <=3.13297 AND it's Easting_X is =101.693463,
then it's ID is 7. And so on...

I have get rid of the = and <= from the criteria. However, i still
dont understand how to use the vlookup function to achieve what i need
after looking at the help from MSExcel. It's quite complicated to use
vlookup function in this situation as i have no experience in using
that function.

Can anyone help me on this issues? Thanks very much. (please forgive
my bad english..)