VLOOKUP Function Error

Posted on 18 October 2008

You think you've entered the right formula and yet you get the dreaded #N/A error on the sheet.....well....here are some useful tips to get you through the vlookup blues! =vlookup(value_to_match, range_to_find_this_value, which_column_to_return , try_to_approximate_if_no_match) (Delimited) text being compared to numbers If you have imported data from a plain text file (a .txt file), your data may most likely have numbers which have been converted to string. Excel will still display the values ... Continue Reading

Comments (2)

60 Useful Excel Formulas That Are Good To Know

Posted on 23 August 2008

60 useful excel formulas that are a good to know DATE = Returns the serial number of a particular date DATEVALUE = Converts a date in the form of text to a serial number DAY = Converts a serial number to a day of the month EOMONTH = Returns the serial number of the last day of the month before or after a specified number of months MONTH = Converts a serial number to a month NOW = ... Continue Reading

Comments     

20 Useful Excel Formulas You Must Know

Posted on 23 August 2008

20 Excel formulas you should know DATEVALUE = Converts a date in the form of text to a serial number DAY = Converts a serial number to a day of the month MONTH = Converts a serial number to a month YEAR = Converts a serial number to a year LEFT = Returns the leftmost characters from a text value LEN = Returns the number of characters in a text string RIGHT = Returns the rightmost characters from ... Continue Reading

Comments