Hi,thanks for your help
I realy don't know vlookup or hlookup is helpful but important thing is that
I want
find "10"s and thier couresponds value in the next or maybe other culumns
from up to down the list
and put them in range H:I as sample, and at end of search don't return N/A
error.
your recommend is so helpful


"JLatham" wrote:

"Wrap" your VLOOKUP or HLOOKUP within an ISNA() function. General format
would be like this:

=IF(ISNA(VLOOKUP(10,A1:C7,2),"",VLOOKUP(10,A1:C7,2 ))


"bijan" wrote:

Hi, I wonder,how can i obtain these below sample data from my list and put
them in specified cells:
A B C .............................. H I
1 . . . 10 1
2 10 1 . 10 2
3 . . . 10 3
4 . 10 2
5 . . .
6 . 10 3
7 . . .
and if not find any thing replace " " insted of N/A error in its last vlookup
Thanks in advance