Automatically input data into one cell when entering data into another cell?

Hi all and what a great site. Will be coming back here often as I'm keen to get as much out of Excel as I can.

I apologise if my thread title is not clear!

Every week I need to create a new spreadsheet which includes amongst other things, venues and map references.

I need to input a venue in one cell on each row and then further along the row in another cell, put in the map reference for that venue.

It's quite a time consuming thing having to look up the Melways map reference eg 34E5 and then input it.

I'm wondering whether it's possible to somehow set the spreadsheet template up so that all of the Melways map references I use are somehow stored as data in the spreadsheet (I'm working with about 40 different map references/venues) and once I type in the venue, Excel is able to automatically input the map reference associated with that venue into the cell further along the row.

Is this at all possible and if so, would someone kindly either tell me how to set this up or point me in the right direction.

Many thanks,

RJ

Hi abousetta and thanks for the welcome.

Good to hear it's relatively simple!

I've made up a mock spreadsheet - you'll see I have put in the venue and then two columns down, the map reference.

Hope this is suitable for you.

RJ

Hi RJSC!!!

Here it is....

Have fun,
Jason..
Test on inputting map references.xlsx

That's exactly what I want!

Thanks Jason. It's great to see it can actually be done. Something like this will save me so much precious time at work!

If you get a chance, can you please explain how you were able to set this up?

Many thanks,

RJ

Yeah.... That's important RJSC.....