Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi Guys, I have a vlookup on cell A5 to give me a result. A5 is itself a result of a copy and paste excercise I continually get an error for the lookup on cell A5, until I edit the cell, ie if I just press F2 (function key 2) on the cell and then return, my lookup returns a response. Any idea why? (its not practical to tell the user to do a F2 on every cell where he / she gets a N/A Thanks, appreciate it Regards D *** Sent via Developersdex http://www.developersdex.com *** |