| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and multiple data
this is in my 1st work sheet
(a1) 500 (b1)Bob (c1)Yes (d1)hants (A2) 500 (b2)Dave (c2)No (d2)surrey (A3) 500 (b3)Rob (c3)Yes (d3)york this is the formula i am using in the next worksheet for a drop down list =IF(VLOOKUP(C8,PowerGate!A3:$L$100,3,FALSE)=0,"",V LOOKUP(C8,PowerGate!A3:$L$100,3,FALSE)) It will show the 500 seperately but what i would like to do is when you select the 500 is to have all of the information for 500 shown in the next sheet.I don't want to have to select it individually. Hope this makes sense. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup With Multiple Instances in Data Table | Excel Worksheet Functions | |||
| VLOOKUP From Multiple Data Sheets | Excel Worksheet Functions | |||
| vlookup - return multiple data | Excel Discussion (Misc queries) | |||
| Vlookup for multiple row data | Excel Worksheet Functions | |||
| VLookup Multiple Data Rows | Excel Worksheet Functions | |||
Threaded Mode
