Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd like to have vlookup return a name if a cell contains the word relief.
And also in consecutive rows. Meaning the word *relief* may be in e.g. 20 cells in a range of 1000. So something like: vlookup "*relief", 'Master'!, O3:O1000,40,false -this lookup would be on another sheet. And if 'relief' was found in rows 26,39,67,75,102, 159, etc., could these results be put in rows 3 to 23, so I don't have to scroll down looking for them. Much thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete rows with specific text | New Users to Excel | |||
Delete Rows Without Specific Text | Excel Worksheet Functions | |||
Transposing data from consecutive rows into non-consecutive rows | Excel Discussion (Misc queries) | |||
Copy/Paste Rows that Contain Specific Text | Excel Worksheet Functions | |||
Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions |