I'm trying to find a function to use on this workbook, but I'm not sure which.

[ahrpr1]

What I'm trying to do is on the Board worksheet there is 1-6 in column A. I am trying to match the names in the Info worksheet to their station numbers on the Board sheet. I have tried using an if statement, but it won't return a value because there are multiple people using the same station. I'd like the Boards to fill themselves out by using a function of some sort, but I am lost as to what I should do. I know this is kind of hard to interpret, but I'd appreciate the help guys!

The file below is the example of what I'm using:
https://drive.google.com/file/d/0BxaZhduwAsdad2x0X1o1bXhFaVU/edit?usp=sharing

 

[venkat1926]

sheet2 is like tis with formula in A3(invoke by control shift enter) and copy right down and across

Excel Workbook
	A	B	C	D
1	station	station	*	*
2	1A	1B	2A	2B
3	rick ladey	b	g	k
4	roger aaron	c	h	as
5	lance armstrong	d	i	m
6	robert downey	e	j	n
7	a	f	*	*
8	*	*	*	*
9	*	*	*	*
Sheet2