How to populate Accounting Field using hourly figure

[ladychurch]

Good morning, everyone!

I would like some suggestions for changing a personal budget spreadsheet I have been using for a few years.

On the Expense sheet, the cell next to Wages (L33) utilizes adrop-down menu which pulls data from a sheet titled Bi-Weekly Wages (='Bi-Weekly Wages'!$B$4:$B$220).



Presently, I have to visit the Bi-Weekly Wages sheet to seewhat dollar amount corresponds with the number of hours worked, andthen select that dollar amount in the cell next to Wages.

Column A on the Bi-Weekly Wages sheet has the hours worked. Column B has the net wages.



What formula can I use that will allow me to enter thenumber of hours worked into a field on the Expense sheet that will populate the corresponding wageamount from the Bi-Weekly Wages sheet rather than referencing the Bi-Weekly wage sheet every time there is a change?

I hope this made sense.

 

[AhoyNC]

Take a look at the VLOOKUP function
Note in the example below the hours are in ascending order.

Excel Workbook
	A	B
1
2	Hours	Wage Amount
3	24	240
Expense

Excel Workbook
	A	B
1	Hours	Wage
2	20	200
3	21	210
4	22	220
5	23	230
6	24	240
7	25	250
8	26	260
9	27	270
10	28	280
Bi-Weekly Wages