Vlookup

[kkerr]

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?

[Pecoflyer]

Nothing I can see at first glance. What is going wrong?
You can post a sample sheet by clicking on "Go Advanced" and "Manage Attachments" in the additional Options window

[kkerr]

I attached a file if it helps

[Pecoflyer]

Firstly, your the range named Divisions is not defined.
Select col E and F and type "Divisions" (no quotes) in the space left of the formula bar

If A1 matches E1, I need it to insert F1 into B

In your exxample col A contains precinct values not values from col E

Is that what you want need ?
If so, try

=INDEX($E$2:$E$200,MATCH(A2,$F$2:$F$200,0),0)

[Kevin@Radstock]

The thing with a VLOOKUP, it looks up to the right. So in your example the lookup table is E2:F200, If you swap the Columns around it should work. Otherwise use the INDEX & MATCH, to which I prefer.

[Pecoflyer]

@Kev

FYI you can also use VLOOKUP to look left like this

=VLOOKUP("x",CHOOSE({1,2},D2:D10,A2:A10),2,0)

( example unrelated to present thread)

[Kevin@Radstock]

Yes I know you can use the CHOOSE Function. I was pointing out to the OP the way the VLOOKUP works!