Hi,
I'm attempting to analyse postcodes but the number format will not allow the lookup function to calculate. I've seen this before but fixed it by copying and pasting. Not this time. If I double click the cell and then enter all is good. But I have 3500 numbers to convert.
Any suggestions?
Thx
See sample attachment
Last edited by TPS; 05-07-2016 at 09:15 PM.
Try with add zeo 0 with Lookup value.
Means as below
=LOOKUP(A2+0
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Try INDEX() and MATCH()
a6 is formate as text, so use a6*1 in the vlookup formula.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
The numbers from A6 onwards are TEXT numbers.
This worked to convert them to numeric numbers.
Select the range A6:A21
Goto the Data tab>Text to Columns
Click: Finish
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks