Results 1 to 10 of 10

Returning multiple Vlooup values

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Phildelphia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Returning multiple Vlooup values

    Hello I am trying to create a vlookup formula that will allow me to return multiple values in separate columns based on one main value. I have attached a sample file that outlines what I am trying to accomplish. Thanks for the help.



    Miami (Cell A2)

    Return value from Sheet 2 Column A based on Cell A2
    Return value from Sheet 2 Column B based on Cell A2
    Return value from Sheet 2 Column C based on Cell A2
    Return value from Sheet 2 Column D based on Cell A2
    Return value from Sheet 2 Column E based on Cell A2


    =IF(A2=0,VLOOKUP(A2,Data!$A$4:$E$15,2,FALSE))
    Attached Files Attached Files
    Last edited by ensmith; 07-13-2012 at 12:28 AM.

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