Forum Discussion
VLOOKUP
The values in A12 and down are text values - they are left-aligned if you look carefully.
The same goes for the values in B12 and down.
Select A12:A21.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click 'Next > ' twice.
Select MDY from the date drop-down, then click Finish.
The values will be converted to 'real' dates.
Next, select B12:B21.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Finish.
The VLOOKUP formula should now work as intended.
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
