• 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.

Vlookup to return entire row

Robjwalters

New Member
Searched and searched and not finding what I need. Sheet 1 has 5500 line items. First column is a email address. On a second sheet I have a list of email address and I need to lookup each of those on sheet 1 and return entire row of data. Thoughts ...
 
simply change the column reference in the vlookup?

Something like VLOOKUP($A2, Sheet2!$A$1:$XFD$1048576;column();false)
Please do refer to the actual range... :)

or INDEX/MATCH combo might be better...

INDEX(Sheet2!A:A;MATCH($A2;SHEET2!$A:$A;0)) and drag down/across.
 
Back
Top