I have a lengthy spreadsheet (16000 Rows with data spanning columns A-H). I
would like to allow user of the spreadsheet to enter a single value into a
cell (A3). I would then like the soreadsheet to search all of the data in
the reference cells, A6:A16023. When a match is located, I would like all
the data in the corresponding row to poulate cells B3:H3.

Example: User enters 4563542 into cell A3. That value is located in
A11546. I would like B3 to poulate with the data from B11546, C3 with C11546
and so on.

Is this possible? If so, can you provide the formula, or at least a sample
that I can work from.