| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Compare 2 column list across 2 sheets
I cannot get this formula to work:
In E2 Sheet2 I have: =IF(COUNTIF($A$2:$B$721,Sheet1!A2:B721)+COUNTIF($E $1:E1,Sheet1!A2:B721)=0,"Entered","") On Sheet2 I'd like to check for data from Sheet1 and place "entered" in column E. This formula gives me "entered" all the way down. Sheet2 has data in it that is exact from Sheet1 plus new data. Can someone please advise? TIA |
|
#2
|
|||
|
|||
|
Gerry,
If I'm understanding correctly, you're trying to compare two columns of data on one sheet with two columns of data on a separate sheet and having Excel return "Entered" when Sheet 2 columns match Sheet 1 columns. If that's the case, try this formula in Sheet2!C2 and drag it down: =IF(Sheet1!A2&Sheet1!B2=Sheet2!A2&Sheet2!B2,"Enter ed","") Knightly Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
| how do i find out what is uncommon in column list A1: A10 and B1:. | Excel Discussion (Misc queries) | |||
| How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Hybrid Mode
