Have you ever tried a VLOOKUP formula in Excel where you’re looking up something that is numeric but stored as text, or vice versa? So annoying, when you seem to have one set of data one way and the lookup in another, right? Today’s #TipTuesday is all about helping you with a couple of formula tweaks to make this a bit easier.
Example 1 – Text to Number
The first example is a simple…
Continue Reading Jen Kuntz’s Article on their blog
Excel VLOOKUP – numbers as text & vice versa
Have you ever tried a VLOOKUP formula in Excel where you’re looking up something that is numeric but stored as text, or vice versa? So annoying, when you seem to have one set of data one way and the lookup in another, right?
Blog Syndicated with Jen Kuntz’s Permission
More About This Author
- Jen is a self-employed Dynamics GP consultant, based in Southwestern Ontario, Canada. She is a Microsoft MVP in Business Applications (since 2016), a GPUG All-Star and a designated accountant (CPA, CGA).
Array
- Dyn365GP30 March 2024Planes, Trains & Automobiles!
- Dyn365GP26 March 2024Decimal Places for HR Benefits
- Dyn365GP21 March 2024New MS Learn AI Skills Challenge
- Dyn365GP4 March 2024Restoring a copy of a GP company reminder