| 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 |
| 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 | |||
Threaded Mode
