dear Zujar, thank you. your large function coupled with lookup worked upto some rank like 3. but after some ranks, its displaying wrong branch names some times. then i checked with excel help of lookup. there, one warning is given as if numbers are not ordered correctly whether ascending or descending, lookup may give unexpected result. so we have to analyse this function more deeply.
Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in