Data validation(lists) and lookup problem

[Andrew-Marsden]

Hi All and thanks in advance for any help given

I am trying to produce an order form which allows users to select parts from a predetermined list,which can be selected by part number or description and autofill each other as required, for instance if I select a description it will autofill part number and if I select part number it will auto fill description,I am stuggling to think of how to do this without vba, it may not be possible.

Andym

[:) Sixthsense :)]

Use Vlookup() Function

[bmouse]

Is this what you're looking for?

This is a simple solution and will only work as long as the names of the parts are all unique. This is because of the specifics of VLOOKUP.

EDIT:

Also this solution only allows for you to select a part by its name - the other values will fill in with VLOOKUP. As far as I know you can't have a drop-down and VLOOKUP in the same cell, that would require a different approach.

[Andrew-Marsden]

Is this what you're looking for?



EDIT:

As far as I know you can't have a drop-down and VLOOKUP in the same cell, that would require a different approach.

Unfortunatly this is the function I require!!

Thanks for your help andy