formula for an excel query

[dhaneshjain]

please give me a formula for the following query

1. match the two columns A and column C for the same account number
   • if they match then check for the respective account price columns say column B and column D that whether they providing the same values if the values match then give result as "correct" in a new column E otherwise result should be "check it again".

 

[pushkardey]

please give me a formula for the following query

1. match the two columns A and column C for the same account number
   • if they match then check for the respective account price columns say column B and column D that whether they providing the same values if the values match then give result as "correct" in a new column E otherwise result should be "check it again".

1. • 
     
     

     =IF(MATCH($A1,$C$1:$C$[U]20[/U],0)>0,IF(INDEX($C$1:$D$[U]20[/U],MATCH($A1,$C$2:$C$[U]20[/U],0),2)=$B1,"Correct","Check it again"),"No Match Found")

     
     Assumptions taken :
     1) you have unique values in Column A and C
     2) you will drag this downwards and this will be against values in Column A
     3)Range is till 20 (change underlined to max data row)
     
     Hope this helps