formula

[anewday777]

i have an excel workbook with multiple sheets, I want to compare the values in collumn a in sheet 6 to sheet "yesterday" and if they match copy column 44 which is notes to collumn 44 in "sheet 6" what is a formula that would accomplish this....I was trying an if error but it wasnt working for me

 

[MountainFog]

Paste in Column 44 on Sheet6: AR1 and copy down

=IF(A1=Yesterday!A1,Yesterday!AR1,"")

 

[Burrgogi]

i have an excel workbook with multiple sheets, I want to compare the values in collumn a in sheet 6 to sheet "yesterday" and if they match copy column 44 which is notes to collumn 44 in "sheet 6" what is a formula that would accomplish this....I was trying an if error but it wasnt working for me

#1) It's unclear what you're trying to accomplish. You said you want to compare column A to a worksheet named "Yesterday" but you failed to mention which particular column you're trying to match.

Sheet6; column A

compare to:
Yesterday; column ??

#2) You should clarify scope of the data you're trying to match. Assuming you have more than 1 number in column A, do you want to match ALL numbers in column A with the other worksheet? Or is there just 1 number involved?

And what do you wish to see happen if only some of the numbers match and some don't? Do you still want to copy the notes column in that case?

#3) You said you have "values" in sheet 6, column A. Are they strictly numbers or do they contain text as well?

 

[Burrgogi]

I should probably add that a formula by itself will not solve your problem here. A formula can certainly match a group of data in one worksheet against another but if you expect to match AND automatically copy a particular column to another worksheet based on the conditions of the match operation, a VBA solution will be required. If you expect an answer, you should clarify the questions above.