Can somebody please help me with a vlookup formula? If A1 matches E1, I need it to insert F1 into B (I tired to copy and paste the table in, but it smooshed it all together)

A1 - 001
B1 - #N/A
C1 - 53729
D1 - 5024722001
E1 - 101
F1 - 20B

The formula I created is =VLOOKUP(A1,Divisions,2,FALSE)
Divisions = E & F

What am I doing wrong?

Attached Files

Test File.xls (32.5 KB, 11 views)