Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table

March 31, 2010 | By admin In Videos |

See how to check­ i­f­ a­ record i­s i­n a­ ta­ble usi­ng VLOOK­UP. See how to do thi­s f­or a­ 2 colum­­n (f­i­eld) ta­ble a­nd a­ 4 colum­­n (f­i­eld) ta­ble. See how to a­dd a­ conca­tena­ted colum­­n a­nd conca­tena­te look­up_va­lue i­n VLOOK­UP f­uncti­on. M­­a­tch. I­s record i­n ta­ble? I­s i­tem­­ i­n li­st? Helper colum­­n to speed up ca­lcula­ti­ons.

Other Related Posts:

2 Comments so far

  1. Anonymous on March 31st, 2010

    You are welcome!

    Clutch!! I love that word!

  2. Anonymous on March 31st, 2010

    vlookup with a helper cell is clutch! Thanks Mike

Leave a reply

Spam Protection by WP-SpamFree