Hope there's an easy solution for this...
Have a validation look-up box (showing review numbers) on a form referring to the 2nd column of another sheet '=INDEX(SUMMARY,0,2)'. By picking a review number from the look-up on the form, the form grabs various info from all rows that have the same review number. The only annoying thing about this is that the look-up shows EVERYTHING in that column, including multiple instances of the same review number.
Is there any way to make the look-up only show one instance of a review number? The help is much appreciated. ray:
Have a validation look-up box (showing review numbers) on a form referring to the 2nd column of another sheet '=INDEX(SUMMARY,0,2)'. By picking a review number from the look-up on the form, the form grabs various info from all rows that have the same review number. The only annoying thing about this is that the look-up shows EVERYTHING in that column, including multiple instances of the same review number.
Is there any way to make the look-up only show one instance of a review number? The help is much appreciated. ray: