Dear all,
Hello, started using more of excel recently due to change in my job profile. So as expected leraning new things on excel everyday. Found this great forum and decided to post my first query.
Okay, so I got customer number in sheet 1 column A1 and blank in cloumn b1. I need to fill this B1 with customer names. In sheet 2, I got customer number in A1 and names in B1.
So if Sheet 1A1= Sheet 2 A1 then the name in Sheet 2 B1 should be copied to Sheet 1 B1. I have a big range. So the current formulae I am using is
=IF(A4=Sheet2!$A$1:A107,Sheet2!$B$1:B107,FALSE)
The first four names got sucessfully copied, but from next its giving False. Please help as to what I am doing wrong?
Best Regards