troubleshooting Question

Help needed with Excel formula

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

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.

Example:
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)
         App1      
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)
              App2      
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,
Excel-question.xlsx
ASKER CERTIFIED SOLUTION
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