In cell H3, enter a formula using the INDEX function. Use a structured reference to the AdLookup table (range A2:E36) as the array. For the row_num argument, use the MATCH function. Use the Ad ID (cell H2) as the lookup_value for the MATCH function. Use a structured reference to the ID column (range A2:A36) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Release Date column number (column 4) as the column_num for the INDEX function.

What is the function for this???

AutoSave O Off) H - SC_EX19_EOM6-2_MargaretSitton_1 Search Maggie DeCarolis MD X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share La From Text/CSV From Picture Queries & Connections Xx Clear GE Group Get Le From Web To Recent Sources Refresh Properties Sort Filter 1 Reapply Text to What-If Forecast a Ungroup Stocks Currencies Data From Table/Range Existing Connections All Edit Links Advanced Columns Ev Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline H3 vix fx =INDEX(AdLookup[ID], MATCH(H2,A2:A36,0),4) A B C D E F G H J K L M N O A D Product Name Channel Release Date Ad Amt Article Information 1082 Jerky chews Pay per click 10/2/2021 250 Ad ID 2142 W N 1532 Exercise track Pay per click 11/4/2021 500 Release Date A # REF! 1654 Training collar with remote control Email marketing 11/7/2021 500 1761 Expandable bird cage Content marketing 10/15/2021 625 Ad Amt 1782 Serene 8-month flea collar Content marketing 10/5/2021 1,000 > 1000 1875 Tunnel and tent for indoor cats Social media 10/21/2021 1.250 Number of Ads 1893 Feline Bites, soft chewables Pay per click 10/12/2021 1,250 10 00 1932 Elevated bed, large Email marketing 11/11/2021 500 10 1950 2-story cat condo Content marketing 10/20/2021 500 Channel 11 1981 Decorative litter box enclosure Social media 10/25/2021 500 Social media 12 2011 Grain-free crunchy bits Content marketing 10/16/2021 .250 Average Ad Amt 13 2048 Retractable leash, reflective Social medic 10/27/2021 LEA 750 14 2060 Airline-approved pet carrier Pay per click 11/4/2021 500 15 2094 Retractable hands-free leash Content marketing 11/1/2021 1,000 16 2118 Silent exercise wheel Social medic 10/7/2021 1,000 17 2134 Classic treat toy Email marketing 10/28/2021 1,000 18 2142 Cold-weather coat Content marketing 10/24/2021 500 19 2151 Healthy Chews dog treats Pay per click 10/22/2021 1,250 20 2176 Waterproof coat, small Social media 10/19/2021 500 21 2187 Stacked tracks Social media 11/10/2021 1,000 22 2203 Super plush bed, medium Social media 10/10/2021 625 23 2208 Scratching post Social media 11/6/2021 500 24 2216 Window cat bed Social media 10/10/2021 500 Documentation October Sales Proposed Discounts October Ads Ad Lookup + Ready Accessibility: Investigate " - - + 100% 7:56 PM Q Search W X 7/1/2023