I have a sheet(sheet 1) with 4 columns of data. We'll say the columns are titled
ACCOUNT, AMOUNT, DATE, ID. I have another sheet(sheet 2) with a bunch of account numbers. I want to see if the accounts in sheet2 are listed in sheet 1 and if they are i need the data that corresponds to the amount data for that account. Any idea on how I can do that?
ACCOUNT, AMOUNT, DATE, ID. I have another sheet(sheet 2) with a bunch of account numbers. I want to see if the accounts in sheet2 are listed in sheet 1 and if they are i need the data that corresponds to the amount data for that account. Any idea on how I can do that?