Thread: how to use vlookup/find etc to extract rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default 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)
Reply With QuoteReply With Quote