Ok, i realize that looks pretty bad here are better examples :

Spreadsheet 1


Spreadsheet 2


Now what i need to do in spreadsheet 2, in column D, bring back the
resulting value of a lookup from spreadsheet one based on if B2 (spreadsheet
2, "model" is A101, go to spreadsheet 1 and find the region (usa123) and
bring back the qty of A101 in region USA123 (should be 15). Jeez i hope that
makes sense to someone.

TIA

James