Forum Discussion
VLOOKUP
I receive date each month on funds, with their unit value. Beginning in June, the data I received came from a slightly different method, and now my worksheet cannot pick up values using VLOOKUP. It ...
I'm assuming you have data for other months and they are working okay?
Yes, I think it works okay for dates prior to June 16, when the data was coming from a different source. At least, it was produced by a different procedure which has worked fine for the last several years.
- I hope you see my second reply. I replied to myself. LOL. Here it is again...
What I just explained is one way to do it. NOT the easiest. I didn't quite get what Hans was doing, but now that I do, that is the EASIEST way to do it. Just remember on the very first screen, choose "Fixed" width. This will stop Excel from automatically using the "/" as a delimiter giving the result you got. - I agree with Hans Vogelaar that the data from 3/16/2023 and down, both columns, are text values not Date and Number values. I was able to recreate your issue. Depending on if your data is imported directly to your table or not, will depend on how many steps you will need to take. One step you will have to take is converting to Dates and Numbers, You do this with two different formulas, =DATEVALUE and =NUMBERVALUE. They are both fairly straight forward to use and the "Help Using This Function" on the lower left corner of the Dialog Box will walk you through it. When you use the =DATEVALUE function, you will get a number as the result. Just use Format Cells to format as a Date. Reach out if you need more help on this Good Luck.
- What I just explained is one way to do it. NOT the easiest. I didn't quite get what Hans was doing, but now that I do, that is the EASIEST way to do it. Just remember on the very first screen, choose "Fixed" width. This will stop Excel from automatically using the "/" as a delimiter giving the result you got.
- Thank you for your help and suggestions. I will experiment to become more familiar with the procedure to make this adjustment each month.