• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Referencing another worksheet and pulling in lines of data

S

S12.9.2014

New Member
I am referencing another worksheet and pulling in data using a VLOOKUP. What I am looking to do is pull in the data below also. I can't use CONCATENATE. I am pulling in several columns of info using the VLOOKUP, but I want to pull the rows of data that are below as well. Is there a forumula that tells me what cell my vlookup is pulling from and then in my row below simply reference the above cell and minus 1 to get the information that is directly below that line in the other worksheet, for example?
 
Hi ,

The MATCH function does exactly that ; unlike the VLOOKUP function which returns data from a matched location , the MATCH function returns the location ( cell position within the data range ) of the match.

Thus , if your data range is J7:J106 , and if the match is found at J33 , the MATCH function will return the number 27 , which is because J33 is the 27th location starting from J7.

Narayan
 
You must log in or register to reply here.
Back
Top