comparing cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how I can compare the information in two different
cells. The cells contain both letters and numbers. If a cell in column "A" is
equal to a cell in column "B" then I want the information in column "C" that
is on the same row as the as the information in coumn "B" to be placed in
column "D" that is in the same row as the information that is being compared
in column "A". Is this possible? So if A1=column B then the cell next to B
(C)would be put in cell "D" in the same row as A.
 
You may use this formula in column D:
=IF(A2=B2,C2,"")
It will show blank if A and B are not equal, you may change that default
value.

Hope this helps,
Miguel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM Char 9
search function 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Comparison of columns using Conditional Formatting 3
Hide columns based on row values 2
Lookup multiple cell values and place contents in a single cell 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
lookup with multiple condition, but one condition to satisfy is en 2

Back
Top