C
chris100
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
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