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.