View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default Find a cell with a word and then return the next cell down

Hello all,
I'm looking to find the word "Credit Card Information" in column A and then
return the value or text in the cell below it.
So, the word "Credit Card Information" is in cell A15, I then need to return
the value or text in cell A16. But, I would also need to return the value in
cells A17-A23.

But, the word "Credit Card Information" will not always be in cell A15, it
will move around in column A, but I will always need the next 8 cell data
below that.

And, if at all possible, Im not looking for a VB code on this one.

Thanks