I have vlookup that isn't working properly and i believe it is because the cell I am trying to lookup isn't properly formated as a number.
I am trying to look up a cell in E1, it is a zip code. It is a formula that says =Right(D2,5) which pulls the last 5 characters from the cell next to it. How can I tell excel to recognize this zip code as a number?
This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm),
I will briefly cover:
1) An overvie…
Workbook link problems after copying tabs to a new workbook?
David Miller (dlmille)
Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.