|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 14th, 2002, 04:04 AM
|
#1 |
|
New Member
Join Date: May 2002
Posts: 2
|
I need a formula that compares the data in a cell to the data in another cell on a different sheet. (different sheet is called directions)
I have been using =IF((a1=Directions!a1),1,0) for example I now need a formula that compares two sells data, ie compare a1 to directions a1, and b1 to directions b1. It needs to bring up a 0 if both don't match, a 1 if one or the other matches, and a 2 if both match. I have tried to come up with this one and am stuck. Anyone know the answer? Thanks |
|
|
|
May 14th, 2002, 04:09 AM
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
Here you go mate
=IF(A1=Directions!A1,1,0)+IF(B1=Directions!B1,1,0) Audiojoe [ This Message was edited by: Audiojoe on 2002-05-14 03:10 ] |
|
|
|
|
May 14th, 2002, 04:14 AM
|
#3 |
|
New Member
Join Date: May 2002
Posts: 2
|
Fantastic!
That ones been bugging me for ages! |
|
|
|
|
May 14th, 2002, 04:20 AM
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,319
|
You can spare some cycles by not using IF: =(A1=Directions!A1)+(B1=Directions!B1) Aladin |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
