troubleshooting Question

Help needed with Excel formula

Avatar of shland
shland asked on
Microsoft Excel
6 Comments2 Solutions216 ViewsLast Modified:

I have 2 applications, data was migrated from App1 to App2. each app has a gui (front end) and a db(back end). I have the db mapping between the 2 applications and from that I need to find the Gui equivalent field names.

here I have App1 Gui names and their equivalent label in the db as shown below: (this would be column A and B in my spreadsheet)
Gui1                    DB1
Tag1       compn-name
Tag2       compn-service
Line no       line-num

here is the App2. Gui names and their equivalent label : (this would be column F and G in my spreadsheet)
Gui2                             DB2
TagA                inst.tagnumber
Service                 inst.service
Line number         data.dx

here is the mapping between the databases: (this would be columns K and L in my spreadsheet).
         DB Mapping      
DB1                                  DB2
line-num                      data.dx
compn-name               inst.tagnumber
compn-service      inst.service

I need a formula that will find the Gui mapping between the 2 applications.
so the result should show me:

Tag1      TagA
Tag2      Service
Line no      Line number

Please specify the formula needs to be written in which cell?

Attached is my spreadsheet containing this information.

Thanks, much,
Glenn Ray
US Data Team Lead
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros