I mixed , help me in VLOOKUP()

[3Dmajid]

Hi to all of my frined.
I want to make this simple project in excel 2007 by vlookup code.
- when user enter student's code , will show studen't name.
this is my source in sheet 1 :

\1

this is sheet 2 , when user enter studen't code , will show studen't name in name cell.I wrote this code for name cell :

=VLOOKUP(D2,Sheet1!A1:E5,3)


but you can see in image that when user enter 1386001 (majid's code) will show Ahmad name in name cell.

\1

Why ?
Some body help me.

[antoka05]

Try to change with:
=VLOOKUP(D2,Sheet1!A1:E5,3,False)

If your want to look only for exact match you need to add parameter False.

Regards,
Antonio

[3Dmajid]

Thanks for you'r help , But don't differ !
I added FALSE but doesn't work again.
Some Body help me.

[Josiah]

Is the first pic you showed the actual data range from Sheet1?

[3Dmajid]

yes.it is in sheet 1.

[protonLeah]

Try this one:

Please Login or Register  to view this content.