| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to HLOOKUP a value from another sheet and display all the d
Hi,
Is there a way to HLOOKUP a value from SheetB and display all the result of that value in SheetA? EG. SheetA: A1 Dust Desk Chair Sheet2 Dust Desk Chair D1 OY yu d2 or yi d3 os yt in SHeetA, I need to HLOOKUP "Desk" and to display all the rows in SHeet2, the result should be OY or os in rows... PLease let me know how do I get that??? THank you very very much in advanced. //GK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet - Hlookup, Index, SumProduct or what? | Excel Discussion (Misc queries) | |||
| How do I hlookup a text document object and then display it? | Excel Worksheet Functions | |||
| How do I change the Excel sheet tab bar to display more sheet tabs | Excel Discussion (Misc queries) | |||
| Hlookup search in more than one sheet of excell? | Excel Worksheet Functions | |||
| How do you display the sheet name in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
