Mapping data using formulas.

[kleanchap]

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

 

[alansidman]

crosspost: https://www.excelforum.com/excel-formulas-and-functions/1203965-mapping-data-using-formulas.html

 

[Macropod]

kleanchap: Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html