Can someone help me how to use a formula using a reference to find columns F-G by referencing D/E for the first two pics. Im super confused and havent been able to figure it out. Now say I wanted to use a second sheet what would be the VLOOKUP?

Methods to fill-in blank cells Cells with data missing can be derived in one of two ways r col For example, Field "Course" is composed of Subject "Course Number "Section CoUrseS ACCT 2301-01 | ACCT Subject Course Number r Section | 2301 01 ACCT 2301-02 ACCT 2301 02 So it stand to reason that if the "Course" is blank but you have data in Subject", "Course Number and "Section you should be able to derive the original data in Course It also stands to reason that if you have "Subject", Course Number" and "Section blank, you should be able to derive the missing data from Course For example 236 AM