Two way lookup where row isn't know?
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Two way lookup where row isn't know?

  1. #11
    Board Regular Snakehips's Avatar
    Join Date
    May 2009
    Location
    Coventry UK
    Posts
    4,663
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Two way lookup where row isn't know?

    Quote Originally Posted by AlanY View Post
    TBH, i'm not sure of Snakehips' suggestion or what it's trying to solve.

    the match() in post#4 is looking for the exact match anyway
    Forgive me if I'm being unnecessary but I was thinking of the scenario below.

    Excel 2010
    ABCDE
    1
    2
    3Word2
    4Word3
    5Word3Word4
    6Word7Word2Word5
    7Word1Word7Word2Word2
    8Word2
    9
    10
    11
    12
    131<<Alan
    144<<Snake
    15

    .78



    Worksheet Formulas
    CellFormula
    A13=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),0))
    A14=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),),0)

    Tony

    AbUsing Excel 2002 to 2013
    This line will be updated just as soon as I come up with something, original, witty, profound or interesting. Please don't hold your breath!

    Please remember - we cannot see your workbook nor read your mind.
    Help us to help you, post clear detail of what you have and what you want - from the start.

    A screen shot can save a thousand words!
    Post a screen shot with one of these: Excel Jeanie, MrExcel HTML Maker
    If posting VBA code, please use Code Tags - see: here

  2. #12
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Two way lookup where row isn't know?

    Quote Originally Posted by Snakehips View Post
    Forgive me if I'm being unnecessary but I was thinking of the scenario below.

    Excel 2010
    ABCDE
    1
    2
    3Word2
    4Word3
    5Word3Word4
    6Word7Word2Word5
    7Word1Word7Word2Word2
    8Word2
    9
    10
    11
    12
    131<
    144<
    15

    .78



    Worksheet Formulas
    CellFormula
    A13=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),0))
    A14=MATCH("Word2",INDEX(A1:E10,MATCH("Word1",A1:A10,0),),0)
    no no no, you were right to point it out.
    please accept my apology
    i just couldn't see the typo in my original formula until mod Fluff pointed it out.

    it's Friday afternoon after all.

Some videos you may like

User Tag List

Tags for this Thread

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
  •