• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    Great to see the Forum Police are active here. You two are pretty impressive with your chest puffing and patting each other on the back. As good as I have seen on other forums. One of you may make Lord the way you are going. One of the reasons I don't lurk in forums like these is the issue of...
  2. C

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    Guys guys guys you need to chill out. Starting at the bottom if I have insulted SirJB7 by not putting the correct title, then I do apologise. Not having dealt with the Titled Gentry of this world my manners may be remiss. Now not having met the eminent SirJB7 I need to know what the title has...
  3. C

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    Hui - the formula is not pasted, it is written for the values I want to return. JB7 - I'm not interested in one of the share sites sorry so no file will be loaded. Makes it hard yes, but I value my privacy more. =VLOOKUP(D2,'owssvr(1)'!$B$2:$F$489,5,0) is the formula I am using, where D2 is...
  4. C

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    Not able to test on another computer sorry. The data is sourced from a Microsoft Sharepoint database, which is exported in a table format. I cut/paste it back to text so its as clean as I can get it. No links, new spreadsheet. Next step is bring in copy of existing spreadsheet from another...
  5. C

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    yes it is
  6. C

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    I've imported raw data from another site and am using it as the basis of a vlookup. However, the data in the cell I am looking at in the vlookup formula does not seem to be formatted correctly and all I get it the dreaded #N/A result. If I click on the source data and 'refresh' it, I then...
Back
Top