| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup returning several cells
I'm trying to pull several cells from one worksheet based on a value from
another worksheet. worksheet1 apples oranges pears worksheet2 apples green red ripe oranges naval Florida round pears rotten ready sold Based on worksheet1 apples should return from worksheet2, green, red, and ripe. Any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
| lookup and return range of cells | Excel Worksheet Functions | |||
| Lookup formula - treat no-registered cells as blank | Excel Worksheet Functions | |||
| Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
| Adding cells with alphabet and returning a numbric value | Excel Worksheet Functions | |||
Threaded Mode
