| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use vlookup/find etc to extract rows
At P1 and P2 respectively:
=MATCH("CA",C:C,0) =MATCH("CA",INDEX(C:C,P1+1):INDEX(C:C,1536),0)+P1 Copy down P2 until you get #N/A Enter at Q1 and copy down: =INDEX(J:J,P1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search or find, and extract? | Excel Discussion (Misc queries) | |||
| find a name from a list then extract it | Excel Discussion (Misc queries) | |||
| Find a worksheet and extract data | Excel Worksheet Functions | |||
| VLookUp to extract data | Excel Worksheet Functions | |||
| find a worksheet and extract data | Excel Worksheet Functions | |||
Threaded Mode
