Bijan

Sorry, I must be having one of my dumb days. I see Bijan's illustration and
his formula example and my response is based on that.

Can anyone give another slant on his need, because I can't see it?

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


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