Close

Results 1 to 4 of 4

Thread: Excel vlookup

  1. #1
    DF Jedi jaguar982's Avatar
    Join Date
    Jul 2001
    Location
    Planet ZOD
    Posts
    2,181
    Thanks
    439
    Thanked:        220
    Karma Level
    490

    Default Excel vlookup

    I have a box line 92 column q on a page and i need the result to display on different page line 3 column f i just cant think straight help please i know im gonna kick myself when i see it thanks

    jag
    I'm not racist i hate everybody

  2. #2
    DF PiMP pmg68's Avatar
    Join Date
    Dec 2003
    Location
    Dunstable
    Posts
    256
    Thanks
    83
    Thanked:        37
    Karma Level
    230

    Default Re: Excel vlookup

    in the cell where you want the result to show, type '"=" then go to the page with the cell you want to report on, highlight it, and press return... so, if cell q92 is on Sheet2, the formula in f3 will be =Sheet2!q92

  3. #3
    DF Jedi Brydo666's Avatar
    Join Date
    May 2008
    Location
    Glasgow
    Posts
    3,445
    Thanks
    213
    Thanked:        194
    Karma Level
    498

    Default Re: Excel vlookup

    Quote Originally Posted by pmg68 View Post
    in the cell where you want the result to show, type '"=" then go to the page with the cell you want to report on, highlight it, and press return... so, if cell q92 is on Sheet2, the formula in f3 will be =Sheet2!q92
    That isn't a vlookup - thats purely referencing another cell.

    Use the Insert Function button and find vlookup - it's a bit like a little wizard to help you select the lookup criteria cell, the lookup range/values and define if it has to be an exact match.



    If you do just want to display the contents of another static cell though, pmg is spot on.

  4. #4
    DF Jedi jaguar982's Avatar
    Join Date
    Jul 2001
    Location
    Planet ZOD
    Posts
    2,181
    Thanks
    439
    Thanked:        220
    Karma Level
    490

    Default Re: Excel vlookup

    Thank you

    jag
    I'm not racist i hate everybody

Similar Threads

  1. [HELP] vlookup problem
    By satzzz in forum Programming
    Replies: 9
    Last Post: 12th December 2011, 01:17 PM
  2. help with Excel
    By consoles in forum The Dog and Duck
    Replies: 2
    Last Post: 16th June 2011, 09:19 PM
  3. Excel - vlookup another spreadsheet?
    By Over Carl in forum PC Software
    Replies: 1
    Last Post: 22nd May 2008, 01:59 AM
  4. Excel XP
    By bt2k1 in forum PC Problems
    Replies: 6
    Last Post: 4th August 2007, 10:26 AM
  5. Excel VLOOKUP (jpg)
    By BFG in forum PC Software
    Replies: 3
    Last Post: 5th August 2006, 07:25 AM

Social Networking 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
  •