+ Reply to Thread
Results 1 to 3 of 3

lookup

  1. #1
    Forum Contributor
    Join Date
    07-07-2005
    Location
    England
    MS-Off Ver
    2003 Pro
    Posts
    452

    lookup

    Hi There,

    can someone help with this pls..

    looking at the attached picture, I need to display in column F which column the number '117' appears in.

    So, cell F2 would return 3 because 117 is in column 3 (C)
    cell F3 would return 4 and so on..

    can anyone help?

    Thanks

    John
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi John

    In F2 copied down:

    =MATCH(117,$A2:$E2,0)

    Richard

  3. #3
    Forum Contributor
    Join Date
    07-07-2005
    Location
    England
    MS-Off Ver
    2003 Pro
    Posts
    452
    Brilliant Richard,

    didn't think it would be that easy!

    thanks very much

    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1