If you are getting #NA there are two possiblities
1. The lookup value in H3 is not in the first column of the array Column B
2. Either the value in H3 or the valee in Col B is having decimals are
formatted to display differently..so it will not be a exact match...

The formula should work. Try out with values manaully entered in to the
cell...

If this post helps click Yes
---------------
Jacob Skaria


"Devabrata Mullick" wrote:

By using this argument the outcomes is "#N/A"

"Ashish Mathur" wrote:

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