For some rerason i have copied a column across and the Vlookup does not want to work on the cells. If i double click on the cell and press enter, the vlookup then works!!!??
Not sure why....but i have formatted all cells multiple times thinking this may be the issue.....any help appreciated.
it could be that yoru cells are formated as "Text" try changing the format (including the first cell) to general, then copy again.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
I have tried to format to General, but it does not work. As i said i have to double click into the cell and press enter for it to be recognised. Driving me mad!
did you format to general before putting the formula in there? also you will need to change the format of the cell you are copying from.
If that does not work could you attach the workbook.
I have attached a workbook that shows the issue i am having. If i go the highlighted cell and double-click into the cell and then enter, the formula will work.
Not sure why this is so??
Thanks...any help appreciated
it is hapening because the cells are formated as text, you just need to highlight the whole row, and select the formating option "General"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks