LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Max in array- return corresponding cell [email protected] Excel Worksheet Functions 1 August 22nd 07 03:59 AM
Find First Non blank cell than find column header and return that value Silver Rose Excel Worksheet Functions 10 April 30th 07 05:56 PM
Find a value, return the value of another cell Dave F Excel Discussion (Misc queries) 6 December 14th 06 06:38 PM
Find a cell and return value of cell next to it jeffro2588 Excel Discussion (Misc queries) 2 August 16th 06 05:00 PM
Find a value in a cell and return another value in a differant cel Lew Excel Discussion (Misc queries) 2 December 11th 05 04:56 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"