VLOOKUP with inbeded IF forumla?

[Nutosmrt]

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

             A            B         C          D               E
1	                worker		 Town	
2    Braintree     Tom 		        	       Sammy
3	                Sammy			
4	                Toby			
5	                Alex			
6				
7				
8				
9				
10   Westfield	 Fred			
11	                 John			
12	                 Kong			
13	                 Chhin			
14	                 Phal			
15

Any Help?

[JBeaucaire]

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)

[newdoverman]

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.

=IF(E2="","",INDEX($A$2:$A$14,MATCH(E2,$B$2:$B$14,0)))