Tag Archives: Colin Legg

Colin Legg and “Binary Searches With VLOOKUP”

Check out this entry from Colin Legg: “Binary Searches With VLOOKUP”

“I went for a job interview about a year ago and the interviewer made a passing comment that he didn’t understand why anyone would ever pass TRUE into VLOOKUP’s  range_lookup parameter. There are lots of cases when you might want to do this so I thought a few, nice examples would be a great way to get VLOOKUP week underway.” To Read More Click Here to go to Colin Legg’s Lesson.

PLEASE NOTE that Colin will continue to contribute Excel-lent articles this week for VLOOKUP WEEK 2012! Be sure to check them out at Colin Legg on WordPress

To find more from Colin, visit his blog Colin Legg on WordPress

Advertisements

Colin Legg looks at “Why Does VLOOKUP Return An #N/A Error?”

Colin writes:

VLOOKUP week enters its second day, meaning that it’s time to have a look at how to problem-shoot #N/A errors. On the online forums I frequently see frustrated users asking why their VLOOKUP formula returns an #N/A error, so I hope that some of the reasons I’ve listed below will be helpful to many of you.” …To Read More Click Here to go to Colin Legg’s Lesson

To find more from Colin, visit his blog Colin Legg on WordPress