Getting names for corresponding numbers

Hello Team

Please let me know how to get the names for corresponding numbers.

The name table has been displayed @ B1 thru F3.
An example of name entry has been displayed in J6. That is a manual input corresponding to the numbers present in I6.
In a similar pattern/manner, could you plz let me know if there is any function to input names for the corresponding numbers. Names should be looked up from name table.

Looking forward for your smart response.

Thanks & Regards
KumarSreenivas A

AttachmentSize
AKAs-032714.xlsx16.14 KB

Ah. I see now what you're

Ah. I see now what you're doing. Interesting problem. I have a solution - it's not very elegant, but what I think you need to do is change the entry fields (e.g. cell I7) to something a bit less likely to cause search/replace errors, for example:

<2>, <1> aka <3>, <1>

You'll also have to change the designators in cells B2:G2 to look like that too.

In cell J7 you can then do:

=SUBSTITUTE(I7,B$2,B3)

If you fill that formula right across six cells, you'll end up with the last column equal to what you want, that being:

HICKS, LAURA L aka SARTIN, LAURA MI

Hope that makes sense! I can't help thinking there might be a more elegant way to do it but it escapes me.

Getting names for corresponding numbers

Thanks a lot Chris.

Substitute function is working good but I have a challenge.
The function holds good for names having 3 last names but in the case of 2 last names, the output is not in the disired way.

In Sample2 & Sample3, I have names with 2 last names only.
--->Please help me in showing O13:O17 blank or an elert like "No <4>"

--->Also, in Sample2, the value in O11 is a duplicate of O10. I understand this is a result of absence of <4> but please help me in eliminating duplicates. Because duplicates & slip outs have been the biggest challenges for us while doing this task manually.

Result in O12 is one such discrepancy. Observe either side of aka are equal. This has also resulted in because of absence of <4>.

Could you plz fix all these.

Let me know for any further information

Regards
KumarSreenivas A

Getting names for corresponding numbers

Team..

Could any one plz respond to the mail written on 27th March.

Regards
KumarSreenivas A

Getting names for corresponding numbers

Team..

Could any one plz respond to the mail written on 27th March.

Regards
KumarSreenivas A

Getting names for corresponding numbers

Team..

Could any one plz respond to the mail written on 27th March.

Regards
KumarSreenivas A

Getting names for corresponding numbers

Team..

Somebody....
Please respond to the mail written on 27th March.

Regards
KumarSreenivas A

I think I see what you're

I think I see what you're asking for - would it work if you were to separate the various inputs into different columns (i.e. having "2" in one column, then "1" in the next one, then "MI" in the next one etc? That would make it significantly easier to produce the output.

Also, in the ones that say "234" what are you expecting? "HICKSSARTINWINTLE"? Or is this just a value that hasn't been input in the top table yet?

Chris

Getting values for variables

Thank you for the response Chris.

If there is no option other than breaking the variables then its fine. At last, what we need is output but in a smart way.

Also, when I say 234, it is the combination of values of 2, 3 & 4. Its value should be HICKSSARTINWINTLE. You picked it correctly. However, I have given the input manually for this entry, plz find the attached.

Thanks & Regards
KumarSreenivas A

Hmm ok... is there a chance

Hmm ok... is there a chance you could explain what you're actually trying to do? I think you're probably going about it the wrong way and there's going to be a neat way to do it, but I'm afraid I really can't work out what you're doing from the spreadsheet!

Getting names for corresponding numbers

Chris....
I am sorry for the huge delay made in responding to your question.
Here we go.
We build a data base of party names & property history captured from scanned images.
After a complete cycle of data processing, the data base will be kept online so that the customers can search and find the information.

We came across documents showing multiple last names such as the sample I have shown in spread sheet. I have added another sample for your understanding. Plz have a look.

When name has just 1 last name, there is no problem. But the problem arises when the name has multiple last names. Because we do not know the customer's choice of search. Customer may search the property with any of the multiple last names.

So, we have decided to build the database with all possible entries. For sample-1, we are getting 12 possible entries.
Let us say that maximum no. of last names that we can come across is 3. Here are the challenges that we are facing in coming up with all possible entries:
1. Replication/Duplication
2. Missings

In order to overcome these, we have created a standard format which I have shown in the spread sheet. But still we are finding some slip outs & over postings despite of spending valuable time. Result is...dip in quality.

So, my humble request is ....please automate the format which I have shown in spread sheet.

Chris...
I do not the what is wrong way or neat way but I know there should be a way to automate this. I would be very greatful to your team if you can suggest me the smart way without using VB Script.

Anticipating your quick response...

KumarSreenivas A