Monthly Value Finder

Medium ★★☆

Update the output cells so that each row in column F shows the price from columns C:E that corresponds to the month typed in H3. The month name in H3 will exactly match one of the headers in C2:E2 (e.g., Jan, Feb, Mar). See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

OFFSET MATCH HLOOKUP ROW INDEX XMATCH

Hint

Solution Approach

Past Submissions

Signup or login to make and view submissions. Your work will be saved.

A1 expected value: *

To see an example of the expected output for a given cell, first click on any output cell. An option will then appear to show the expected value for that cell.

Your solution is tested against 3 test cases which you can toggle between. To pass, your solution should use cell references so it returns the correct output across test cases.