Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I only pull rows if the data matches a named range?
I have a sheet in my workbook as a named range. Another sheet has rows of
data with about 20 columns of information for each entity. I want another spreadsheet to pull only those rows if one column matches a value in the named range. Sheet 1/B2:T57 - each field is a different number Sheet 2 - Each row has columns of information about different entities. Column F might match information in a field on Sheet 1 Sheet 3 - Pull all information (entire row) from Sheet 2 only if value in column F matches a field value in the range on Sheet 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find multiple matches of one data item in an excel range | Excel Discussion (Misc queries) | |||
How do I specify column for named range of rows | Charts and Charting in Excel | |||
item # in one sheet want to pull data that matches from other tab | Excel Worksheet Functions | |||
Number of Rows & Columns in a Named Range | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) |