+ Reply to Thread
Results 1 to 2 of 2

return range with vlookup

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    return range with vlookup

    Hi I need to determine if a certain range has text. this range is adjacent to vlookup value.Test Data.xlsx
    In want to refer to the row above any cell in E36:K42 by using vlookup with the number above in row 34 to look
    in column D and returning the adjacent range.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: return range with vlookup

    Provide an example of the results with an explanation. Your post does not seem to apply to the workbook provided.

    Define "range"
    Last edited by protonLeah; 02-19-2018 at 03:07 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-04-2013, 07:23 AM
  2. Vlookup and return value from a range of results?
    By homer123456 in forum Excel General
    Replies: 10
    Last Post: 01-11-2011, 07:41 PM
  3. Replies: 9
    Last Post: 08-17-2010, 02:13 PM
  4. I want vlookup to find a range, and return highest value in that range
    By crazie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2008, 01:20 PM
  5. VLOOKUP - Return sum of all matches in Range?
    By Wiggz in forum Excel General
    Replies: 3
    Last Post: 01-25-2007, 06:42 AM
  6. VLOOKUP: Range & Return
    By Keeper4826 in forum Excel General
    Replies: 25
    Last Post: 01-18-2007, 09:46 PM
  7. Vlookup to Return a Range of Data
    By james in forum Excel General
    Replies: 0
    Last Post: 07-13-2006, 04:50 PM
  8. Vlookup to Return a Range of Data
    By Rob in forum Excel General
    Replies: 13
    Last Post: 05-31-2006, 11:10 PM

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