Search and match value cross multiple sheets and return values

Hi everyone,

If anyone could help me out it would be greatly appreciated. I’ve tried to research myself referring to Youtube and guides, but I get so confused. I think index and match is what I’m trying to achieve.

I have two sheets in my workbook, one being ‘order’ and the other being ‘data’
I need to have the order number picked, and matched in ‘data’ sheet and return the value in column ‘score’

Essentially, on the order sheet for 1-2342241 – I want the score and comment to have 8 and comment in the relevant column.

This is a simplified example, the data I have spans 58 columns, and rows of 50 will be added daily.

Orders!F2:

Formula:

Please Login or Register  to view this content.

Copy F2, select F2:G7, paste.

In your actual workbook you'd need to modify the ranges above for the actual ranges you're using.