+ Reply to Thread
Results 1 to 6 of 6

I mixed , help me in VLOOKUP()

Hybrid View

3Dmajid I mixed , help me in VLOOKUP() 04-07-2008, 10:59 AM
antoka05 Try to change with:... 04-07-2008, 11:08 AM
3Dmajid Thanks for you'r help , But... 04-10-2008, 03:15 PM
Josiah Is the first pic you showed... 04-10-2008, 03:48 PM
3Dmajid yes.it is in sheet 1. 04-11-2008, 02:11 AM
protonLeah Try this one: ... 04-11-2008, 06:40 PM
  1. #1
    Registered User
    Join Date
    04-07-2008
    Posts
    3

    I mixed , help me in VLOOKUP()

    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.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    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

  3. #3
    Registered User
    Join Date
    04-07-2008
    Posts
    3
    Thanks for you'r help , But don't differ !
    I added FALSE but doesn't work again.
    Some Body help me.

  4. #4
    Forum Contributor
    Join Date
    01-06-2004
    Posts
    121
    Is the first pic you showed the actual data range from Sheet1?

  5. #5
    Registered User
    Join Date
    04-07-2008
    Posts
    3
    yes.it is in sheet 1.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,933
    Try this one:
    =LOOKUP(D2,Sheet1!$D$2:$D$5,Sheet1!$C$2:$C$5)
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1