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, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 07 February 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 8,319 times and liked it 51 visitors.
