| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
match or lookup?
I have problem in getting the final table which look like the following:
col A B C D E ... row1 120 PC Keyboard row2 310 Monitor row3 450 Mouse Scanner Server CDROM Our customers normally will give us very long list which look something like this: 120 PC 310 monitor 120 Keyboard 450 Mouse 450 Scanner 450 Server 450 CDROM We can do it by using the filter function and copy the item one by one, but sometimes we did left out some of it. Do anyone have any idea in doing that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup / Match help ??? | Excel Discussion (Misc queries) | |||
| How do i Match all COLUMNS? | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
