Lets say I have a fixed reference such as 86759 in Cell A1 and a date next to it, on my second tab is a weekly changing worksheet with the same reference but the date changes. How can I get tab one cell A1s date to update when the tab 2 date changes. Meaning, I have a primary list of jobs with start dates which is a fixed sheet. Weekly I get updated job list to which the start dates have changed. When I copy and paste the updated report in tab b, I would like my cell reference to find the job number in tab b, and the new date, and update the date on my fixed primary sheet? Make sense? ask away. Thanks in advance
2007-12-19 07:48:38 · 2 answers · asked by NoAnswers 2 in Computers & Internet ➔ Software
As long as the reference is unique on each sheet, you can do a vlookup of the fixed and bring back the date, formatted as such.
Provided I understand the question correctly.
2007-12-19 14:37:14 · answer #1 · answered by pricehillsaint 5 · 1⤊ 0⤋
It sounds like you need to use either VLOOKUP or HLOOKUP. The difference between the two is that VLOOKUP searches vertically and HLOOKUP searches horizontally. Another that you could possibly use is MATCH. The website below explains VLOOKUP and MATCH.
http://office.microsoft.com/en-us/excel/HA011549021033.aspx?pid=CL100570551033
2007-12-20 07:28:57 · answer #2 · answered by devilishblueyes 7 · 1⤊ 0⤋