Heres my situation: In a cell Id like to develo a nested function where I can
search for a string( 8-character serial number) listed in an adjacent cell,
and return a TRUE, FALSE, or custom message depending on whether it finds the
value or not. In my case, the database values I am searching through are all
listed in one column, 15,000 rows deep, and are not sorted in ascending
order. I'm using this as a failsafe to determine if the string (which is the
serial number) actually exists (to make sure the user has entered the serial
number correctly) so that the item can be crossed off the list. I also have
VBA code to highlight the item corresponded with the serial number once the
failsafe function has determined the serial number is correct...