PDA

View Full Version : Checking ref # status based on sheet2 ref #.



aligahk06
04-25-2010, 11:59 PM
Dear All,

I have two worksheet say Sheet1 and sheet2.
Sheet1 is for Jan10 and Sheet2 for Feb10.
Both sheet contains ref# and remarks.
I want to check that if ref# is common on both sheet i.e say sheet1 and sheet2 then return the remarks of both the sheet.
i.e if ref# 2612A found on both sheet then in Sheet3 i want status of ref# 2612A in following format and so on for all Ref # based on Sheet2.


Sht#. Remarks from sheet1 Remarks from Sheet2




Note:- If ref# of Sheet2 is not available on sheet1 then return as Ref # not available on sheet1.

Any formula or macro or code that solve my problem.

Please help,
Attachment is the sample file.

Rgds,
Aligahk06