tag:blogger.com,1999:blog-8807805591547673516.post7370446831886517940..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_From A FirstName LastName Database Extract In NewNames Sheet FirstName LastName For A List FirstName_MI In OldName SheetYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8807805591547673516.post-20739465641594215802013-05-10T07:07:58.379-07:002013-05-10T07:07:58.379-07:00after modifying the formula to work with my data, ...after modifying the formula to work with my data, I am receiving unexpected output. When there are 6 'Tom"'s it is giving them all, one after the other, and then continues on with the list. I need the list order to stay the same as the original data, and on an error or multiple names, skip the cell so i can manually pick which name it is. Is this possible?<br /><br />Here is the link. I have modified the sample data<br /><br />https://docs.google.com/spreadsheet/ccc?key=0AvTqJBK5ZdjNdGpJS2tNZUY4bEY2cjRSWGNFZzBnUEE#gid=1Anonymoushttps://www.blogger.com/profile/07162057740637502430noreply@blogger.com