Please Help!

[MicahM]

I'm trying to figure out how to use some sort of conditional formating that will enable me to take a collumn of data and use an IF function to name the data in the cell to the right of the data.

The trick is that I want to have Collumn A (sheet1) compared to Collumn A on (sheet2). And then if a value is found to match in both collumn A's then on collumn B (sheet1) is filled by the value on collumn B (sheet2).

The reason I'm trying to solve this is because I have an enourmous spreadsheet of account numbers. Several of the account's data got corrupted and so the type of account is now missing . I have another spreadsheet that contains the accounts/account type and I need to have the first spreadsheet find the account on the second spreadsheet and fill in the account type.

I hope that I was able to communicate my problem. I need help from an Excel wizard!

Thanks in advance for taking a look at this for me.

 

[manojrf]

Hi,

Though I am not an expert, I have used my brain to help you. I think you have the main data in Sheet 2 , account number in column A and type in column B.
What you want to do is ,when you enter the account numbers in column A of Sheet 1 , the corresponding account type should be picked up from column B of Sheet 2 and the correct value has to be put in column B of Sheet 1, right ? If this is the case,then put this formula in column B of Sheet 1.

=IF(ISNA(IF(MATCH(A1,Sheet2!A$1:A$15,0),VLOOKUP(A1,Sheet2!A$1:B$15,2,FALSE))),"",VLOOKUP(A1,Sheet2!A$1:B$15,2,FALSE))

This formula returns a 'blank' ,if the correct match is not found. If you need to change this 'blank' to some other, say "Not found" or "Incorrect",enter the text as you wish in place of "".

Regards, Manuel

 

[T. Valko]

I'm trying to figure out how to use some sort of conditional formating that will enable me to take a collumn of data and use an IF function to name the data in the cell to the right of the data.

The trick is that I want to have Collumn A (sheet1) compared to Collumn A on (sheet2). And then if a value is found to match in both collumn A's then on collumn B (sheet1) is filled by the value on collumn B (sheet2).

The reason I'm trying to solve this is because I have an enourmous spreadsheet of account numbers. Several of the account's data got corrupted and so the type of account is now missing . I have another spreadsheet that contains the accounts/account type and I need to have the first spreadsheet find the account on the second spreadsheet and fill in the account type.

I hope that I was able to communicate my problem. I need help from an Excel wizard!

Thanks in advance for taking a look at this for me.

See if this is what you had in mind:

http://contextures.com/xlFunctions02.html