Thread: If a cell equals _, at the next row that equals _, return value fr
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
  
Posts: 1,397
Default If a cell equals _, at the next row that equals _, return value fr
try
=offset(A1,match("Joe's Hardware",A:A",0),6)

"CathyH" wrote:

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