Mapping data using formulas.

I have 2 sets of data in 4 columns. DB1 is the main database. DB2 is the information extracted from a vendor application.

Worksheet1(DB1-SystemName DB1-ipaddress)

Worksheet2(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 is completly assigned to a 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

https://www.mrexcel.com/forum/excel-...-formulas.html