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!


--
Git24
------------------------------------------------------------------------
Git24's Profile: http://www.excelforum.com/member.php...o&userid=37268
View this thread: http://www.excelforum.com/showthread...hreadid=569816

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=569816

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=569816