VBA Match Cells, Copy Adjacent Cells

[Lelewiwi]

Hi all - I've been searching for days for a solution and have yet to find one that works. Doesn't necessarily need to be VBA, but I think it has to be as formula's don't seem to work. I have 2 sheets "Split Request" and "Hidden".

Split Request has account numbers in cells E9:E47. These are in numerical order.
Hidden has account numbers in column A. These are not necessarily in numeric order.

I need something that will search Hidden, Column A for a matching account number from Split Request E9:E47. If a match is found, it should copy the adjacent cell from Column B to the adjacent cell of the account number on Split Request, column F.

Thanks so much for the help!

 

[Lelewiwi]

OMG, you rock! That worked perfectly!

 

[Fluff]

In that case col E are text & col A are numbers.