Vlookup does not work on certain description Hi, I tried using vlookup to find v

Question

Vlookup does not work on certain description

Hi,

I tried using vlookup to find values associated with below item descriptions but the function returned nothing when the associated values were actually there.

111C~Correct   InvceN/A

Could anyone let me know how to overcome this problem? Thank you for your time and help,

111C~Correct   InvceN/A

111F~FreightN/A 111M~Assortd ShrtsN/A 111N~NSFN/A 111R~Restock ChrgeOSFA 111S~Service ChrgeN/A BST501~IROSFA GFCT~Gift CertifctN/A K540~IRM PRESENTBOBasic gromL PRESENTBO~District.comS RACKRH Metal BaseOSFA SCA15FCD vA w/o $OSFA

Explanation / Answer

Hi..

When looking for a Tilde(~) you must double up on it (~~) because it is a wildcard.

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.