This is my 1st post and hopefully I get it right.

I receive a monthly worksheet with Office and salesman along with Sales dollars

The problem is that this monthly spreadsheet does not indicate what region the office resides in.

I do have another spreadsheet that has listed Office number in one column and region in another column

I would like to compare 1st spread sheet to the 2nd and pull the region from the 2nd into the 1st when the offices match

Spread Sheet 1
OFFICE SALESMAN
123 45
133 92
123 48


Spreadsheet 2

OFFICE REGION
101 Western
123 Southern
127 Southern
133 Central
166 Northern