Is it possible to have an ID returned when selecting a Name?
I have a workbook where sheet 1 is a form used to load data into a database. One of the columns on the form is Company ID. Sheet 2 has a table with Company ID (column A) and Company Name (column B). I am trying to get a data validation list where users can find and select the appropriate Company Name but the field is actually populated with the Company ID.
Any help or suggestions is greatly appreciated.
Norm
Bookmarks