My test data only went to row 6, so I didn't get all the formula ranges
changes. Let me try again:

H1:
=IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",10)
Enter with control + Shift + Enter rather than just enter since this is an
array formula

I1:
=IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",INDEX($C$1:$C$7,SM ALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10)0,ROW($A$1:$A $7)),ROW(A1)),1))
Entered with Ctrl+Shift+Enter rather than just enter since this is an array
formula

Select H1:I1 and drag fill down the column.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
H1:
=IF(ISERROR(SMALL(IF(($A$1:$A$6=10)+($B$1:$B$6=10) 0,ROW($A$1:$A$6)),ROW(A1))),"",10)
Enter with control + Shift + Enter rather than just enter since this is an
array formula

I1:
=IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",INDEX($C$1:$C$7,SM ALL(IF(($A$1:$A$6=10)+($B$1:$B$7=10)0,ROW($A$1:$A $7)),ROW(A1)),1))
Entered with Ctrl+Shift+Enter rather than just enter since this is an
array formula

Select H1:I1 and drag fill down the column.

--
Regards,
Tom Ogilvy




"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