Use INDEX to search a different worksheet bur return text in different column

I have a workbook with two worksheets. I'm trying to figure out how to use INDEX for VLOOKUP but return a different value that was was found. Example is below.

Sheet 1 contains:
A B C
1 Type Model Error Code
2 Server Dell 12345
3 Workstation HP 678910

Sheet 2 contains:
A B
1 Error Code Fix
2 12345 Reboot
3 678910 Install memory

What I'm trying to do is match the error codes in both sheets and then return the Fix to a new column in Sheet 1 so it would look like:

A B C D
1 Type Model Error Code Fix
2 Server Dell 12345 Info from Sheet 2!B2