Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Vlookup Technique Help

  1. #1
    Board Regular
    Join Date
    Jul 2009
    Location
    On Planet Earth
    Posts
    829
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Vlookup Technique Help

    Hey,
    Plz Need Help In This Loopup Technique

    Sheet2

     ABCDEFGHIJKLM
    2FormulaMy RangeTables List DataResults Table1Table2Table3
    3#N/AA1:A9Table2 A1100 A11A1100A11000
    4    A2101 A22A2101A21001
    5    A3102 A33A3102A31002
    6    A4103 A44A4103A41003
    7    A5104 A55A5104A51004
    8    A6105 A66A6105A61005
    9    A7106 A77A7106A71006
    10    A8107 A88A8107A81007
    11    A9108 A99A9108A91008
    12       A1010A10109A101009
    13       A1111A11110A111010
    14       A1212A12111A121011
    15       A1313A13112A131012
    16       A1414A14113A141013
    17       A1515A15114A151014

    Spreadsheet Formulas
    CellFormula
    A3=VLOOKUP(B3,C3,2,0)


    Excel tables to the web >> Excel Jeanie HTML 4


    My look Up Formula Is In Cell A3
    In Cell B3 The "Lookup Values" It's The Range From "A1:A9"
    In Cell C3 The Data List Including Table 1,2,3 "Table Array"
    My Results Of Shoul Be In Cells F3:F11

    How Can I Apply This

    Thanks In Advance
    it is more blessed to give than to receive. Act 20:35
    And whosoever shall give to drink unto one of these little ones a cup of cold water only in the name of a disciple, verily I say unto you, he shall in no wise lose his reward. Matthew 10:42



  2. #2
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,292
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup Technique Help

    Hi,

    I don't really understand the use of A3 and B3 but maybe you could name the table ranges H3:I17, J3:K17, and L3:M17 as Table1, Table2 and Table3 and then use formula:

    =VLOOKUP(E3,INDIRECT($C$3),2,FALSE)

    in F3 copied down.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Board Regular
    Join Date
    Jul 2009
    Location
    On Planet Earth
    Posts
    829
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup Technique Help

    http://www.mrexcel.com/forum/showthread.php?t=424814 Plz Take A look At Original Post This Thread Duplicated With My By Error
    it is more blessed to give than to receive. Act 20:35
    And whosoever shall give to drink unto one of these little ones a cup of cold water only in the name of a disciple, verily I say unto you, he shall in no wise lose his reward. Matthew 10:42



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com