I have two columns of data. The first column is random, multi-digit ID numbers and the second column are dates that are specific to those ID numbers (i.e. 2234 matches 3/3/95 only) I want to be able to go to another workbook or sheet and type in a random ID number from the first column and then have excel generate the corresponding date next to it. I want to be able to do this with a sheet that has 400+ ID numbers with dates, go to another workbook and start typing ID numbers down column A and then excel generate it's date in column B
Solved by X. E. in 19 mins