I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be the master sheet.
Then if there is no owner in sheet 1, I want to assign the owner from sheet two. Please can someone explain how this is done? I have given a similar example of my document below. Sheet 1 contains around 460 rows, sheet 2 contains around 580.
I have attached an example, please can you help?
Missing in Sheet 1
in Sheet2!D2
=IF(ISNA(MATCH(B2,Sheet1!B$2:B$10,0)),"Missing","")
Missing Owners: Cells can either have a value or a formula - not both. If you want a result you will have to create a Helper Column, ie another column that looks at the Owner column and if its has a value pulls it in otherwise looks at Sheet 2 for the owner but it cant be in the same cell as the Owner on Sheet1. The alternative to this is VBA which can put values in cells but this is a more complicated process. So use a Helper column for now.
in Sheet1!D2
=IF(C2="",VLOOKUP(B2,Sheet2!B2:C100,2,0),C2)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks