nick
I posted an illastration

"Nick Hodge" wrote:

Bijan

I'm sorry if I'm not understanding, but presuming tbl is a range name, then
just copying the formula down (Dragging using the fill handle if you like)
should change the references in the formula as the lookup value (A1 in your
example) is relative and when dragged down to the next cell down that will
automatically become A2 so you will be looking up the value in A2 in your
range (tbl) and returning the match 3 columns to the right in tbl.

To return a blank when you get a #N/A then use the formula structure I
posted so you end up with, in H1

=IF(ISNA(VLOOKUP(A1,tbl,3,FALSE)),"",VLOOKUP(A1,tb l,3,FALSE))

Now just copy this to the cells below


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"bijan" wrote in message
...
in"H1" =vlookup(a1,tbl,3,false)
But it just return first value from my table, i need obtain secound record
in H2 and so on

"Nick Hodge" wrote:

Bijan

Post your current formula

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"bijan" wrote in message
...
Yes, you are right,but how can i do it , should i write 4 formula from
h1
to
h4?

"Nick Hodge" wrote:

or even wrap ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Nick Hodge" wrote in
message
...
Bijan

I Think you will need to warp it in an IF(ISNA... like

=IF(ISNA(Your_Original_Vlookup),"",Your_Original_V lookup)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"bijan" wrote in message
...
Hi experts

Please solve this plane sample with formula

A B C .............................. H I
1 . . . ..............................10 1
2 10 . 1 ............................. 10 2
3 . . . ..............................10 3
4 . 10 2 .............................N/A N/A
5 . . .
6 . 10 3
7 . . .
insted of N/A in last vlookup replace blank
Thanks in advance