#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Help me
 
Posts: n/a
Default comparing cells

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default comparing cells

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.

"Help me" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Cells gdeleos Excel Worksheet Functions 2 March 16th 06 08:22 PM
how do i protect cells in a shared worksheet Debi Excel Discussion (Misc queries) 3 September 30th 05 11:15 PM
Display first, second, etc Nonblank Cells in a Range Jeremy N. Excel Worksheet Functions 12 September 25th 05 01:47 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"