Google Sheets: Vlookup and Match to lookup based on column header instead of column index
Vlookup searches for a value in a range and returns the value in a column specific by the column's index or number
↓ see slides/demo sheet below for more information ↓
Using vlookup() with match() allows you to return the value in a column based on its header instead of index: this is great for cases when columns might move or or when columns are added that change the column's original index. See the slides and use the link to make a copy of the demo sheet to see and try this yourself:
Slides: https://docs.google.com/presentation/...
Copy Demo Sheet: https://doittraining.page.link/copyvl...
#spreadsheet #googlesheets #vlookup #vlookupfunction #matchfunction
Watch video Google Sheets: Vlookup and Match to lookup based on column header instead of column index online without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 07 February 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,319 once and liked it 51 people.