Hi Guys,
I have a dropdown list pointing to a column within my collection.
My collection for example has columns models, ID's, and Row Numbers.
When a user selects a model I would like to know the Id for that particular model.
Now I know I can use a lookup formula although the problem is there are duplicate model numbers with different ID's.
A lookup will only give me the first match. I have added in a row counter to try and get the row of the selected model so then I can match it back to the ID.
A gallery will allow me to get the correct value although I don't want to use one in this instance. I need to use a dropdown.
Is there anyway to get row information on the selected dropdown model item ?
Any help is greatly appreciated.
Thanks
