Hi all,

This is either incredibly easy problem or very hard - i've searched for an answer here and elsewhere but with no luck.

Basically, i need a pull down list that references two columns but only uses the data in the first column for data entry.
The reason is i may have the same products from different suppliers so need to differentiate between them.

So in case i didn't explain clearly enough - First column in the pulldown list would be "Product", second column would be "Supplier." Both would be visible in the pull-down list, only the product would be entered in the cell.

Any help would be much appreciated, as always,

Thanks,

Chris