Thread: vlookup again
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default vlookup again

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