AnsweredAssumed Answered

Excel Question -Match Data from Two Excel Files that Share Similar Attributes

Question asked by kenric03 on Apr 13, 2015
Latest reply on Apr 14, 2015 by kenric03

Hello,

 

I don't know if anyone knows this answer, but I thought I would give it a try here in our GeoNET.  I need to do this first so that I can update it in GIS.

 

I have two different Excel spreadsheets. They have almost the same data, but it has been updated so some entries are not there anymore or some items have been added.

 

I have some items that are labeled "I" or "O" for inside or outside in the "E" columns. I need these in my new spreadsheet, and there are 300 or so of them.

 

The values that are the same and need to match are KVA, LOW_VOLTAGE,COXX, and HIGH_VOLTAGE (rows A, B, C, and D).

 

I would like to somehow have the formula look at these values from the original sheet, and if they are the same, it will put an "I" or "O" in the field "E" in my new sheet.

 

Thank you very much for helping me!

 

Capture.JPG

Outcomes