View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bijan bijan is offline
external usenet poster
 
Posts: 44
Default VLOOKUP , HLOOKUP

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