0

I have pulled data from two databases, and would like to match Column A data, with column B if it matches then show result in column D with the corresponding row value of column C.

Excel Data excel data

What I need: combine excel data

If column A code matches with column B then it should show data with matched column A and corresponding column C value.

Luuklag
  • 3,897
  • 11
  • 38
  • 57
Adil
  • 1
  • 1
  • 1

1 Answers1

0

The examples are the same, but based on what you've said it's a straight up if formula =if(a2=b2,c2,"")

Basically is a2 is the same as b2, enter in c2, otherwise nothing.

Jake Bourne
  • 723
  • 3
  • 10
  • 27