I IKHAN Member Jul 18, 2017 #1 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 Test.xlsx 10.6 KB · Views: 17
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
N Nebu Excel Ninja Jul 18, 2017 #2 Hi: Something like this? Thanks Attachments Test.xlsx 11 KB · Views: 39
N Nebu Excel Ninja Jul 19, 2017 #5 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
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