Help with Formulas

[Git24]

I am trying to create a formula which links a date to two specific number's (differnet columns) within the spreadsheet. How do i do this, without a massive 'if' statement. Basically there are 3000 factory order numbers in column A and Column B contains a line item for each. This information is pulled from a report on a weekly basis and the information will be pasted into the spreadsheet in question every week. Each factory order number has a date associated with it and this is the date we need to link.

Please Help!

[starguy]

please put a sample format of your data and explain which type of link you want?

[robert111]

on a separate sheet list all order numbers and their associated dates, make this into a named table, and then use VLOOKUP on your first sheet to pull in the order number