Mapping data using formulas.

kleanchap

New Member
Joined
Oct 8, 2017
Messages
1
I have 2 sets of data in 4 columns. In DB1 is the main database. DB2 is the information extracted from a vendor application.

DB1-SystemName DB1-ipaddress DB2-SystemName DB2-ipaddress


What I am trying to achieve using excel formulas is to map the data elements to DB1 elements. The DB1 are the primary key set.
The challenge is that some of the systems in DB1 are upper case and while the systems in DB2 are lower case. Sometimes the ipaddress has a completly different system name.

I tried using =IF VSLOOKUP functions but was not successful.

Could you please let me know how to do such mapping without having to use VBA?

Thank you in advance.

K
 

Forum statistics

Threads
1,085,307
Messages
5,382,849
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top