Is this possible? if so, how?
I have a workbook where sheet1 is a list of accounts available for use. Sheet 2 is a list of accounts currently being used.
Is there a way in sheet1 (I tried vlookup unsuccessfully but may not have been using it correctly) that I can distinguish between the accounts available for use and the accounts currently being used by simply using one formula?
example. if sheet1 contain (a2:10) 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 as available
and sheet 2 contains (a2:a5) 2,3,6,7,8 as being used how can I differentiate in sheet1 the accounts that appear in sheet2?
If I only had 10 accounts it wouldn't be an issue, but I have many, many, many, many more and it would take me hours, hours and many more hours to determine which accounts were not being used.
Anybody know if this is possible?
Thanks
G-
Bookmarks