View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen271077 Karen271077 is offline
external usenet poster
 
Posts: 1
Default can I use IF function to compare 2 columns


Hi

I currently have 2 reports ... Both have peoples names in it. I would
like to compare the names in one report to the names in the other
report. If the names are the same I want the report to state ok, if
not it needs to state WRONG

Workbook 1

Column A Last Name
Colum B First Name
Column C Location
Column D - OK? WRONG? Is the last name in WB1 = the last name in WB2

Worksbook 2

Column A Last Name
Colum B First Name
Column C Location

PLEASE HELP ME .......:(


--
Karen271077
------------------------------------------------------------------------
Karen271077's Profile: http://www.excelforum.com/member.php...o&userid=36195
View this thread: http://www.excelforum.com/showthread...hreadid=560961