Good morning
I have a large list of postcodes in a column, with 7 columns next to that with each day of the week listed as a Y or N if a delivery can be made to that postcode on that weekday.
I would like to set up a text box where you can type in the postcode, that then looks up the code in the postcode list and returns the value for what days delivery can be made.
For example, in the text box, AA1 1AA is typed in and then S M T W T F S gets returned as Y or N based on the post code.
I have included a couple of pics of what data i have and how I would like to present it.
Ideally without userforms, but open to it.
Thanks in advance!
I have a large list of postcodes in a column, with 7 columns next to that with each day of the week listed as a Y or N if a delivery can be made to that postcode on that weekday.
I would like to set up a text box where you can type in the postcode, that then looks up the code in the postcode list and returns the value for what days delivery can be made.
For example, in the text box, AA1 1AA is typed in and then S M T W T F S gets returned as Y or N based on the post code.
I have included a couple of pics of what data i have and how I would like to present it.
Ideally without userforms, but open to it.
Thanks in advance!