The site formerly known as Code For Excel and Outlook
January 22, 2010 by · 
In Return value if in range in excel, Oscar shows us a formula for returning values in a column based on a number range. Let's review his formula and also provide a few more that can do the same thing simpler.
Continue Reading: Getting an approximate match from a range »
October 24, 2008 by · I have a worksheet with a list of company names in column A (we'll call it 'Worksheet1'), and another worksheet with a list of similar company names in column A ('Worksheet2'). Both lists have a header row, so the data starts in cell A2 of each worksheet.
Continue Reading: Worksheet matching to return row number »
Site last updated: February 8, 2012
Follow Me