Results 1 to 4 of 4

VLOOKUP - Get value from column other than first.

Threaded View

  1. 03-26-2009, 02:07 PM #1
    redinferno
    redinferno is offline
    Registered User
    Join Date
    03-26-2009
    Location
    127.0.0.1
    MS-Off Ver
    Excel 2003 on one computer and Excel 2007 on another computer.
    Posts
    2

    VLOOKUP - Get value from column other than first.

    I want a value to be searched for in column M and its corresponding value in column A to be returned.

    This is the formula I am using:
    =VLOOKUP(79, A3:M22, 1, FALSE)
    The value 79 is searched for inside column A.

    I want it to be searched for inside column M. But since VLOOKUP searches the first argument of the array ( the array specified in the second argument ) I don't know how to do this.

    How can I overcome this problem?

    Thanks in advance.
    Last edited by redinferno; 03-26-2009 at 03:03 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1