Compare column A on two different worksheets, if match copy column b

    I want to compare column A on sheet1 and sheet2, if a match is found copy the value from column B on sheet2 in the same row as the match cell.


    Thanks.

    Re: Compare column A on two different worksheets, if match copy column b


    see if this helps


    =IF(ISERROR(MATCH(A1,Sheet2!$A$1:$A$27,0))=FALSE,INDEX(Sheet2!$B$1:$B$27,MATCH(A1,Sheet2!$A$1:$A$27,0)),"")

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login