Learn how to return an entire record when performing a lookup operation, such as when using the XLOOKUP function or VLOOKUP function..
File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_ReturnRecord.zip
00:49 File Download Instructions
01:08 Understanding the Data
01:22 Building the Report Environment
02:25 Building the Data Validation Dropdown List
04:48 Testing the TRANSPOSE / XLOOKUP Formula
05:12 Solution using the VLOOKUP Function
06:20 Error Checking the VLOOKUP Function
07:20 Visualize Record Position Using Conditional Formatting