vlookup maybe?

[Dxmiian]

Hi,

I have 2 sheets.. Sheet A(Order) I have column A and B.. Column A is blank but has title Locations. and column B is Barcodes. I post barcodes in for a order as and when I need them. Sheet 2 (Layout) has full range of all stock with locations. Locations in column A and Barcode in column B I want to pull certain locations into sheet A to show locations for specific order not the whole range.. could someone help,

thanks

[Dxmiian]

I have this but its not returning column A from sheet 2, its returning column B... =VLOOKUP(B2,Layout!B2:B2000,1,FALSE)

[Fluff13]

How about
=INDEX(Layout!$A$2:$A$3000,MATCH(B2,Layout!$B$2:$B$3000,0))