Bioinformatics Training and Education Program

VLOOKUP in excel and the R programming equivalent

Coding Club Seminar Series

VLOOKUP in excel and the R programming equivalent

 When: Mar. 15th, 2023 11:00 am - 12:00 pm

Seminar Series Details:

Presented By:
Alex Emmons (BTEP)
Online Webinar
Organized By:

About this Class

Do you use excel's VLOOKUP function often to merge tables or search for subsets of data in large NGS data files? If so, you may be interested in a more programmatic solution. Join us for a lesson on performing VLOOKUP in excel followed by a more reproducible solution with R programming. Whether you are interested in merging a list of gene ids with a table of functional annotations or searching for unique matches of known T-Cell Receptor sequences among output from a 10X TCR sequencing run, this tutorial will likely be useful to you.  

This tutorial will kick off the BTEP Coding Club, which features monthly 1-hour tutorials of bioinformatics tools, software, or skills. Email us at if you would like to see a topic featured by the BTEP Coding Club.