compare value then print out a name

[membio]

hi,

i have a database that looks like this:
a1 b1 c1 d1 e1
234 john 1981 portugal yes
456 mary 1984 portugal no
643 gary 1946 england yes
387 larry 1978 brazil no
267 sarah 1979 india yes


i want to be able to when i enter the number 234 in a sheet it prints on another column the correspondent country, in this case "portugal".

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[membio]

http://www.mediafire.com/?6c6cqwhjud0r404 (1)

http://www.mediafire.com/?oi6kk1ukd8nk687 (2)

i don't think Vlookup can work, or i am confused....
here on the links, you can see what i want:

on (2) i have the database.
on (1) if i entered for example the 844 value (on top) it would search in (2) for the 844 value, fetch the correspondent country and automatically print it on (1)...

i don't know if i'm being clear, lol :P

 

[VoG]

Example

Excel Workbook
	A	B	C	D	E	F	G	H
1	234	john	1981	portugal	yes		456	portugal
2	456	mary	1984	portugal	no
3	643	gary	1946	england	yes
4	387	larry	1978	brazil	no
5	267	sarah	1979	india	yes
Sheet2

 

[membio]

thanx, it worked out great!