Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a workbook that contains 2 sheets.

One is a master forms list and the other is a log for document control changes.

What I would like to have happen is, when I make a new entry into the Document change control log, look for the form number in the master list and then enter the DCN number, Rev level, and Date to match what I entered in the DCN log.

I have very little experience with formulas. Is this something that is possible to do?

share|improve this question
1  
Yes, it is, but the result done with formulas is volatile; if you change the master list, the value will change. Perhaps it is not something you will want to happen if you work with logs. –  Adam Ryczkowski Sep 29 '12 at 8:52
    
A little sample data might help clarify your requirement, and which version of Excel? Regarding @Adam Ryczkowski's caution, could you create the master forms list by extraction from the DCN log - or perhaps just apply a pivot table to the DCN log? –  pnuts Oct 31 '12 at 21:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.