• 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 for wrapped text contents in cell

IKHAN

Member
Hello ,

Looking for assistance to extract row from matched data from sheet 2

Issue is - unable to lookup data if entry is wrap text or used ALT /ENTERin sheet 2

Using below formula

=VLOOKUP($A2,Sheet2!$A1:$H8,3,FALSE)

Attached sample file

Thank you
 

Attachments

Nebu

Excel Ninja
Hi:

I didn't get you , the formula looks up value if a part of your look up value is present in your search string. If you want exact match you should give exact lookup values and do normal Vlookup.

Thanks
 
Top