Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
vlookup & hlookup | Excel Worksheet Functions | |||
vlookup and hlookup | Excel Worksheet Functions | |||
VLookup and HLookup at the same time | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions |