Excel icon

Getting an approximate match from a range

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 »

Excel icon

Worksheet matching to return row number

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