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)

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I attached a file if it helps

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

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

Is that what you want need ?
If so, try

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

@Kev

FYI you can also use VLOOKUP to look left like this

( example unrelated to present thread)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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