Results 1 to 3 of 3

Thread: VLOOKUP or INDEX & MATCH

  1. #1

    VLOOKUP or INDEX & MATCH



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Could someone kindly inform me why neither my VLOOKUP or INDEX and MATCH is working

    Thanks a million
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    The formats of Column A and E don't match.

    You can either change column E to match, by selecting the column and going to Data|Text to Columns and simply clicking Finish.

    Or account for the difference in the formulas:

    e.g.

    =VLOOKUP(""&A2,$E$2:$F$2300,2,FALSE)

    and

    =INDEX($F$2:$F$2300,(MATCH(""&A2,$E$2:$E$2300,0)))

    The ""&A2 coerces the A2 to text format to match column E's text format.


  3. #3
    Excellent response

    Thanks a million

Posting Permissions

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