Dropdown lists

[Lidia Simmons]

Hi experts,



I have written a form for entering my travelling expenses. I have used a
list of destinations and round trip miles, (I4:J25) to avoid retyping.

E4 = VLOOKUP(D4,$I$4:$J$25,2,FALSE)

I have set column D, validation to list, in-cell dropdown, $I$4:$I$22

This works well until I try to put my list on a different worksheet. It
seems that I cannot validate across worksheets.

Is there a workaround for this?



Please be gentle

I am a new bee.



Regards,

Stan. S.

 

[Frank Kabel]

Hi
you have to define a name for your source list ('Insert - Name -
Define'). e.g. listsource
Now use this name as data source in the data validation dialog. e.g.
=listsource

 

[Bob Phillips]

Yes, you have to give the list a workbook name (Insert>Name>Define Name..)
and use that name in the list definition instead of a range.

 

[Stan Simmons]

Thanks Frank & Bob,
It works perfectly. Isn’t it easy when you know how?

Regards,
Stan Simmons