ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   only a certain text from a target col (https://www.excelbanter.com/excel-discussion-misc-queries/260798-only-certain-text-target-col.html)

Narnimar

only a certain text from a target col
 
I have a large data sheet of order pending list in which I look for a text in
$B$2175 and determine the area of target cells. In this sheet they can be
found in between the resulted row from
ADDRESS(ROW(INDIRECT("B"&MATCH($B$2175,B:B,0))),1) and
ADDRESS(MATCH($B$2175,A:A,0),1)
The formula to return my needed text is if result of
MID(INDIRECT("A"&MATCH($B$2175,A:A,0)-(MATCH($B$2175,A:A,0)-MATCH($B$2175,B:B,0)+3,2,3)
= €œPO-€œ This will extract and return items based on €œPO-€œ in the column but
I need to use draghandle and extract only required value. How can I
incorporate a drag feature instead of +3 given in this formula so that even
the target row exists in other rows than 3rd row in the same column?



All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com