Debug — Lookup Range Drifts on Drag

A junior analyst's account-status lookup works in row 2 but returns #N/A (or wrong values) for every row below it. They wrote:

=INDEX(G2:G6, MATCH(A2, F2:F6, 0))

The reference table at F2:G6 is correct, and the customer codes in column A are correct. The formula even returns the right answer for B2. But when they dragged it down to B3, B4, …, the references shifted: G3:G7 and F3:F7 for row 3, G5:G9 and F5:F9 for row 5, etc. — and most of those shifted ranges fall outside the reference table.

The fix: lock the reference range with absolute ($) references so it stays put as the formula drags.

Reference (build at F2:G6 if not already there):

Your task:

1. Write a corrected formula in column B that returns the right status for every customer code in column A.
2. The formula must be drag-down friendly — $ on both the INDEX range and the MATCH range.

Graded cells: B3, B4, B5.