• 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.

any function ? error

C

chris.db

New Member
I have 2 problems:


1. I have data that giver every minute one value, I need to make new table that takes only data from every 5minutes, like in picture, when is not available data for 5. minute than it should take last (4.minute)


http://imageshack.us/photo/my-images/844/problem1b.jpg/


2. problem


when I make vlookup and last parameter is FALSE I get error , but when I put TRUE a I get different number, like in picture


http://imageshack.us/photo/my-images/155/problem2n.jpg/


thank you in advance, or I can post xls files if it is needed
 
Not sure about #1, but I can help on #2.

When the last arguement is FALSE, VLOOKUP searches for an exact match of the lookup value. If it's not found, an error is returned. If you use TRUE, the function looks for closest match and interally assumes that your data is sorted as it searches from top to bottom. Thus, you should always get an "answer", it just might not be what you want.
 
You must log in or register to reply here.
Back
Top