Need Conditional Text Display and Selection

[pardeepsingh]

I am a newbie to excel.
I have a file with postal codes for a particular town along with the dates when my team will be there.
I want to make a new sheet and then on the second sheet if someone starts typing a postal code, then dynamically it searches for the item containing the text types and also displays the corresponding dates. I think this can be done through drop down lists.

I am hereby attaching the sample sheet.

Would be really thankful if someone can do this for me.


Thanks

[JBeaucaire]

This can be done with a worksheet_change event watching column A of your new sheet. As you type in zip codes in that column, it will add the matching dates to the right on the same row.

Please Login or Register  to view this content.

[pardeepsingh]

Thanks for the solution

It really works, but how do i find a match for the Alpha-numerically closest ZIP code and its corresdponding date.
For example, I am looking for code K2P 1N1 and the date for this particular code is not present in the list.
Then, it should display the dates for the alpha-numerically closest match, ie, any of the codes in K2P series.

Thanks

[pardeepsingh]

This can be done with a worksheet_change event watching column A of your new sheet. As you type in zip codes in that column, it will add the matching dates to the right on the same row.

Please Login or Register  to view this content.

Thanks for the solution

It really works, but how do i find a match for the Alpha-numerically closest ZIP code and its corresdponding date.
For example, I am looking for code K2P 1N1 and the date for this particular code is not present in the list.
Then, it should display the dates for the alpha-numerically closest match, ie, any of the codes in K2P series.

Thanks

[JBeaucaire]

1) please don't quote my entire post into yours.

2) Add this, if there is no "exact match" to the zip entered, it will search again using only the first 3 characters.

Please Login or Register  to view this content.

[pardeepsingh]

Thanks A ton It works.

[JBeaucaire]

Glad to help.

If that takes care of your need, please click Thread Tools above your first post and mark this thread as SOLVED.