VLOOKUP Across Rows And Columns

The row in blue is a successfully created result from my VLOOKUP formula:

The row in red is unsuccessful.

=VLOOKUP($A$11,$A$3:$G$9,(COLUMN($B$2)))

The above formula lives in the blue "Pottery" cell (cell B11 in my spreadsheet).

How can I get this VLOOKUP formula to work in rows below it?

When I just copy and paste the formula into row 12 (in red text), the formula still refers to row 11 (in blue text), and I get the same exact results no matter what unique signifier I put in (see the red row for unsuccessful results).

It's strange because in the successful blue row, I simply copied and pasted from cell B11 through G11, and everything came out fine due to the relative(??) identifiers, but no luck transferring that formula to rows.

My unique identifiers seem to be off the page, but they are just 1 (starting at Old Masters) through 6 (at Impressionist).

When I type 6 (for the red row), I get the same results as for when I type 5 (for the blue row), so my unique identifiers aren't registering somehow.

Item Code

Dept
Description
Qty.
Price
In stock
Line Total

1
Old Masters
Painting
100
5

2
New Masters
Sculpture
200
10

[Code] ........