Assign ID based on condition(criteria)

[changeable]

Thanks for the reply. Basically i neet to assign the corresponding I
number to each row in my data field. However, there are 4 types o
criteria matching condition which is illustrated as below:
1.
In order to assign "1" next to a particular row(to assign 1 in the
column), the value of Northing_Y should matched those stated in Row 11
(Northing_Y >=3.137263 and <3.138149)
2.
In order to assign "7" next to a particular row(to assign "7" in the
column), the value of Northing_Y AND Easting_X should matched thos
stated in Row 116 ( Northing_Y<=3.13297 AND Easting_X >=101.693463).
3.
In order to assign "8" next to a particular row(to assign "8" in the
column), the value of Easting_X should matched those stated in Row 11
( Easting_X >=101.692597 AND <101.693463)
4.
In order to assign "9" next to a particular row(to assign "9" in the
column), the value of Northing_Y AND Easting_X should matched thos
stated in Row 118 ( Northing_Y >=3.131821 AND Easting_X <101.692597)


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

The attached is a refined data table and criteria table, can someon
show me how to use the vlookup function by using this worksheet
Thanks

+-------------------------------------------------------------------
|Filename: sample.zip
|Download: http://www.excelforum.com/attachment.php?postid=2762
+-------------------------------------------------------------------