Thread: If a cell equals _, at the next row that equals _, return value fr
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CathyH CathyH is offline
external usenet poster
  
Posts: 25
Default If a cell equals _, at the next row that equals _, return value fr
This is an example of what I'm trying to do:

If a row in Column 1 = Joe's Hardware
Take the next row below Joe's Hardware that is called Paint Brushes and
return the value from Column 7 in the same row

I can't for the life of me figure out how to do it.
Reply With QuoteReply With Quote