Vlookup Column Index Number

I have a situation where I am using Vlookup and the Column Index Number is located in a row before the Lookup Value.

I have attached a file for reference: The Employee number (lookup value) is in column D of the worksheet, but the Job Title (column index number), on the Bonus Sheet, which needs to be updated based on changes to the Master sheet, is in column B.

How do I indicate a Column Index Number? Anything I have done produces
#N/A.

Thank you.

Brandy

Try this

=INDEX(Master!B:B,MATCH('Bonus Sheet'!D2,Master!D:D,0))

Worked a treat Martesoft. Thank you.

Since you've seen the file, I have one more question:

How can I update the Bonus Sheet when new entries are made on the Master? On the Master a position of 'Waiter' was added - is there a formula I can use which would update the Bonus Sheet any time the Master is updated?
Thank you.

Brandy