=VLOOKUP($BA$2,'S:\[abcd.xlsx] Database'!$S:$T,2,FALSE)

this formula does not copy accross. instead of picking its respective column its taking BA column for all cells.

Can some one please help