HI,
I am working with a workbook (2 worksheets - Data (WS1) and Consolidation (WS2)) and am trying to consolidate dome of the data based on 1 parameter from a specified cell that contains multiple parameters. When I use Vlookup, it always gives the first row.
I want to search column A in WS1 for the *Text* and have it return the adjacent cell (column B WS1) to my designated cell in WS2.
Problem I have - in WS2 there are only necessary 15 rows to be displayed yet there is ~200 rows to search, I only want to return , to WS2, the 15 occurrences from the 200 rows on WS1.
Does this make sense? I hope so...
Please help,
Kenn
I am working with a workbook (2 worksheets - Data (WS1) and Consolidation (WS2)) and am trying to consolidate dome of the data based on 1 parameter from a specified cell that contains multiple parameters. When I use Vlookup, it always gives the first row.
I want to search column A in WS1 for the *Text* and have it return the adjacent cell (column B WS1) to my designated cell in WS2.
Problem I have - in WS2 there are only necessary 15 rows to be displayed yet there is ~200 rows to search, I only want to return , to WS2, the 15 occurrences from the 200 rows on WS1.
Does this make sense? I hope so...
Please help,
Kenn