Comparing two sheets

Closed
Report
Posts
1
Registration date
Saturday July 4, 2015
Status
Member
Last seen
July 4, 2015
-
Hello guys, trying to do a spreadsheet at work for a stock take but a little bit more automated.

The basic sheet is there but the csv that comes from our Back of House till system with amount sold comes in a different (unwanted) order.

I'd like to make an array that will sort through all the columns in column b, if b4 matches say c35 in the second sheet, it will be make b5 equal to d35.

Is this at all possible?

Thanks!