The formula only works when I copy data from one cell and Paste Special and then select Values.
I have attached a sheet with more info on.
The formula only works when I copy data from one cell and Paste Special and then select Values.
I have attached a sheet with more info on.
Last edited by mrcois; 08-23-2010 at 09:22 AM.
Some of the values in Column N are actually "preformatted" as Text.
Select column N and then go to Data|Text to Columns and click Finish.
Then Format the column as General (or Number, 0 decimals).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Your lookup table seems to be one column
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi
The formula works fine for me copying and pasting normally
Regards
Jeff
It actually works for me typing in.
Thanks guys, but what NBVC said worked for me...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks