Download Excel File: https://ift.tt/2svzovY
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to Lookup Based On Row Number with Data Validation For Row Number. Here are the topics:
1. (00:06) Introduction
2. (01:01) INDEX Function too pull data based on row number
3. (02:16) ROW Function to get first row in data set
4. (02:48) MATCH & REPT Functions to get last row number.
5. (05:23) Data Validation to limit on the row numbers in the correct range
6. (06:41) Text Formula for informative label
7. (07:48) Summary