Share |

Archive

Posts Tagged ‘lookup’

Reverse cell Lookup

February 1st, 2012 1 comment

reversecelllookupsecrets.com – discover the name, address, city, state of those unknown cell phone calls www.youtube.com

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

January 28th, 2012 25 comments

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. See an INDEX and MATCH functions formula that uses SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW functions. This is a data extract with 2 criteria using a formula solution. Return Multiple Items From One Lookup Value. Related Videos: Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column, Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row List Winning Bets With Array Formula

Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble

January 28th, 2012 4 comments

Extract data with MID and use VLOOKUP to retrieve a date. See how to lookup the middle part of a text string and return a value when the substring is a number shown as text. See how to convert numbers as text to numbers inside a formula.

Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup

January 25th, 2012 25 comments

See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) excelisfun: Names, INDIRECT function and the Space Intersector Operator in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) YTL Excel #119: Amazing Lookup Solution! Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup Excel Name Trick #7: INDIRECT function, Names and LOOKUP Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup MrExcel’s Learn Excel #965 – Two-Way Lookup Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH

Reverse Phone Number Lookup.wmv

January 24th, 2012 No comments

MobilePhoneNumberLookup.net Get access right now to the owner of any phone or cell phone number by doing a reverse number look up.

Excel Lookup Series #14: CHOOSE function

January 22nd, 2012 24 comments

See how to use the CHOOSE function to select an item from a list. This function is useful if you want to type the lookup table into the function itself! In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.