Table - 1 : -
A B C D E
Start_SR End_SR Qnty Party Item
1 1 10 10 A X
2 25 50 26 B Y
3 75 100 26 C Z
4 200 600 401 E XX
5 2156 2550 395 D YY
6 1500 1599 100 F ZZ

Table - 2 : -
SR Party Item
2 =VLOOKUP(H3,B2:E8,4,1)
1100
500 =LOOKUP(H5,B2:E8)
76
1200
2200
In Table-1 I have some data with a range ( Columd A - B) which range billed
out against the party and item...... want to pick up the Party & Item in the
Table-2..... I used these two functions.... but it is working when the both
data is shorted and takes the nearest value....... But i want to the exact
value and randomly........

Pls help.....

Regards,
Devabrata