Formula only works for the first cell with that value

[Tindall80]

Hi

I'm trying to populate the column with data between different worksheets. I have entered the code (below) and apllied it to a column. The results only one cell with a value from the migrated site list sheet, even though there are many sites noted in column A which are also in column A in the 'Migrated site list' sheet.
=IF(A3='Migrated site list'!A:A,A3)

I have checked that the format on both sheets is general. I have triedadjusting the formula, however it always provides the same result.

Any assistance would be appreciated.

[FDibbins]

Hi and welcome to the forum
That looks like an array formula...

...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[Pete_UK]

I think what you want is something like this:

=IFERROR(VLOOKUP(A3,'Migrated site list'!A:A,1,0),"")

Hope this helps.

Pete