A slightly different Excel Question..

Chr15_2

I have designed a sheet using Excel which includes two drop down menus. For example a registration number is entered from a drop down in one box and then enter a fleet number in another. At the moment I have two drop down menus to do this which works Ok BUT what I want to do is..if I enter a registration number the fleet number is automatically entered into the next box. Can anyone help me out with this at all? Thanks in advance.

KingL

via a lookup table? vlookup or hlookup (depending whether you want it horizontal or vertical) see under the helptext for each of those....

GunJack

could set up a reference table in another sheet, then have a vlookup in the cell next to your drop-down selection to look up the registration to your reference table to import the fleet number. Advantage of doing this is that you just need to update the reference table as & when

GunJack

KingL wrote: »

via a lookup table? vlookup or hlookup (depending whether you want it horizontal or vertical) see under the helptext for each of those....

snap !!

Chr15_2

Sorry must admit I'm newish to Excel as far as this goes, what does this mean?

Lokolo

In A coulmn, put all registration. In B column, all fleet numbers in.

Then in a random cell put =LOOKUP(D2,A1:A20,B1:B20)

then in D2 enter the reg number.

I think that works!

GunJack

^^ that's the basic idea

the final version will include an IF(ISERROR..... so that the not-yet-looked-up cells will remain blank until the corresponding registration cells have been filled in...if I get a minute in work later, I'll post an example

littlepanther

If you're new to Excel check out https://www.mrexcel.com he has some good tutorials and so does https://www.jargonfreehelp.com/excel.asp both free with short very good video clips, I'd start with Jargon Free for IF and VLOOKUP.

If you really want to learn Excel in more detail there is lynda.com but there is a subscription..

LP

Chr15_2

Hi thanks all for the help,I know what I'm doing this weekend now