Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Max in array- return corresponding cell | Excel Worksheet Functions | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Find a value, return the value of another cell | Excel Discussion (Misc queries) | |||
Find a cell and return value of cell next to it | Excel Discussion (Misc queries) | |||
Find a value in a cell and return another value in a differant cel | Excel Discussion (Misc queries) |