View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vegas Sara Vegas Sara is offline
external usenet poster
 
Posts: 1
Default multiple sheet lookup or match

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.