| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data
I have a xsl file with two sheets One is named data and other is named info
lets say. On the data sheet lets say there is cell a1:z50000 I need to pull every cell in a row that c3:C5000 matches up with A1 on the info sheet. I just want to type in lets say mike in A1 on the info sheet. in cell a2 to what ever it will pull all cells from the data sheet that that matches A1 on the info sheet to data on c3:c5000 on the data sheet. I need some help on this one. Thanks -- Greg KY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
| Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
| pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
| Pulling data | Excel Worksheet Functions | |||
| Pulling data from web | Excel Discussion (Misc queries) | |||
Threaded Mode
