Results 1 to 3 of 3

Vlookup Technique Help

This is a discussion on Vlookup Technique Help within the Excel Questions forums, part of the Question Forums category; Hey, Plz Need Help In This Loopup Technique Sheet2   A B C D E F G H I J ...

  1. #1
    Board Regular
    Join Date
    Jul 2009
    Location
    On Planet Earth
    Posts
    706

    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,178

    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
    706

    Default Re: Vlookup Technique Help

    Vlookup Technique Help 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



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