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 ...
Thank you for the help. I think I have col B fixed correctly. However, when I followed your instructions for col A, I have it split into 3 columns as shown. I must have done something wrong on the "text to columns" procedure. I am certain you can steer me in the right direction.
Thank you.
When you convert the dates, make sure that all the check boxes for delimiters in step 2 are cleared.
Step 3:
Result attached.
- Great solution! I've used this many times but not how you used it. I didn't get it at first, but when I tried it, pretty darn slick. I learned something new from this. Every once in a while my data comes in as text. I'll use this method to convert it. THANK YOU!
Thank you, Hans, that works perfectly! Thank you so much for your expertise and help.
Dapper49
