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