Thread: If a cell equals _, at the next row that equals _, return value fr
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default If a cell equals _, at the next row that equals _, return value fr
Maybe one way could be done like this:

=IF(A18="Joe's Hardware",INDIRECT("G"& (ROW(A18)-1) + MATCH("Paint
Brushes",A18:A100)))

Regards,
Paul

"CathyH" wrote in message
...
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