VLOOKUP with inbeded IF forumla?

I need Column D2 to state the town Sammy is working in. I have =VLOOKUP(E2,B2:B15,1,False)

Please Login or Register  to view this content.

Any Help?

From that table, what town is Sammy working in? Briantree?

VLOOKUP works reading columns LEFT to right, so you would need to:

1) Put the names in column A
2) Put the city for each person in each row
3) Expand the VLOOKUP range to include columns A:B...

=VLOOKUP("Sammy", A:B, 2, 0)

I found your example more than a little confusing but came up with a solution that I think fits the situation. The cities have to be filled in in column A for each worker.

Formula:

Please Login or Register  to view this content.