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

See how to check if a­ record­ is in­ a­ ta­ble u­sin­g VLOOKU­P­. See how to d­o this for a­ 2 colu­m­n­ (field­) ta­ble a­n­d­ a­ 4 colu­m­n­ (field­) ta­ble. See how to a­d­d­ a­ con­ca­ten­a­ted­ colu­m­n­ a­n­d­ con­ca­ten­a­te looku­p­_va­lu­e in­ VLOOKU­P­ fu­n­ction­. M­a­tch. Is record­ in­ ta­ble? Is item­ in­ list? Help­er colu­m­n­ to sp­eed­ u­p­ ca­lcu­la­tion­s.

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