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
|