Thread: Lookup formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rowland Rowland is offline
external usenet poster
 
Posts: 18
Default Lookup formula

I am looking for a formula to find the first row in a column that
contains any data.I can do it with an array formula
INDEX(rng,MATCH(TRUE,rng0,0)) but was curious if some can do it without
using an array formula,perhaps with LOOKUP