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 ...
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.
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.