Hi,

Instead of 1 in the last arguent, use a 0

=VLOOKUP(H3,B2:E8,4,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Devabrata Mullick" <Devabrata wrote in
message ...
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