View Single Post
 
Old 05-16-2011, 06:37 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Backwards Searching Using a Formula

Hi
I am seaerching for a formula that will reverse search a single column array for the first non blank cell and return the number in the cell to the right of that value.
For example:

A10 contains "Object Number:", B10 contains "2456"

Current Active Cell is A20
Search from A20 backwards to A10 and then when it finds the cell is non-blank then return the value in B10.

Any help would be appreciated.
Tony
Reply With Quote