Hlookup is driving me to distraction

[johnstan]

Hi
I have a workbook that has pricing breaks per purchased quantity and I want to look across another sheet within the work book and find the unique number then populate the value from the cell in the adjacent column. I had originaly been trying Hlookup but can't get that to look at the adjacent column.

On the exaple workbook I would like the formula to be created in cell D2 (Unique number concatonated with quantity) on the "Lookup Sheet", to look across the "Data sheet" and return the value in cell J6 on the Data sheet, and then copy that down and across the other unique numbers


I have tried index,match but I am really struggling with this, any help would be greatly appreciated as I am at the loosing sleep stage...

Regards
John