I have created a sheet, that anyone can access (if you can copy and make the edit in yours, then that would be appreciated) 
And data is in the sheet Roles-location-salary. Please note, in that sheet, the salary values are per year, but in the "Expense" sheet I need to have it divided by 12 to get the monthly value.
I tried taking inspiration from Vlookup, but could not get it to work. Any help will be appreciated as to what the formula could be?
CodePudding user response：
Suggestion
You can try a combination of IF,VLOOKUP,HLOOKUP, & MATCH formulas to achieve your goal:
Method
[UPDATED]
=IF(VLOOKUP(B2,'Roles-location-salary'!A:Q,2,FALSE) = A2, HLOOKUP(C2,'Roles-location-salary'!A:Q,MATCH(B2, 'Roles-location-salary'!A:A,0),FALSE),'Roles-location-salary'!R1)/12
Demonstration
The value returned was divided by 12 to get the monthly value