software

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.

Don,

try to create the formulas as:

On the B3 cell, quot;=vlookup(a3;A6:h16023;2;0)
On the C3 cell, quot;=vlookup(a3;A6:h16023;3;0)
On the D3 cell, quot;=vlookup(a3;A6:h16023;4;0)
On the E3 cell, quot;=vlookup(a3;A6:h16023;5;0)
On the F3 cell, quot;=vlookup(a3;A6:h16023;6;0)
On the G3 cell, quot;=vlookup(a3;A6:h16023;7;0)
On the H3 cell, quot;=vlookup(a3;A6:h16023;8;0)

As you can see the last number before 0, (...;2;0) refers to the number of
the collunm on the area.
quot;Don - Mundane Government Workerquot; escreveu:

gt; I have a lengthy spreadsheet (16000 Rows with data spanning columns A-H). I
gt; would like to allow user of the spreadsheet to enter a single value into a
gt; cell (A3). I would then like the soreadsheet to search all of the data in
gt; the reference cells, A6:A16023. When a match is located, I would like all
gt; the data in the corresponding row to poulate cells B3:H3.
gt;
gt; Example: User enters 4563542 into cell A3. That value is located in
gt; A11546. I would like B3 to poulate with the data from B11546, C3 with C11546
gt; and so on.
gt;
gt; Is this possible? If so, can you provide the formula, or at least a sample
gt; that I can work from.

Thanks, that got me in the right direction.

quot;Marceloquot; wrote:

gt; Don,
gt;
gt; try to create the formulas as:
gt;
gt; On the B3 cell, quot;=vlookup(a3;A6:h16023;2;0)
gt; On the C3 cell, quot;=vlookup(a3;A6:h16023;3;0)
gt; On the D3 cell, quot;=vlookup(a3;A6:h16023;4;0)
gt; On the E3 cell, quot;=vlookup(a3;A6:h16023;5;0)
gt; On the F3 cell, quot;=vlookup(a3;A6:h16023;6;0)
gt; On the G3 cell, quot;=vlookup(a3;A6:h16023;7;0)
gt; On the H3 cell, quot;=vlookup(a3;A6:h16023;8;0)
gt;
gt; As you can see the last number before 0, (...;2;0) refers to the number of
gt; the collunm on the area.
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;Don - Mundane Government Workerquot; escreveu:
gt;
gt; gt; I have a lengthy spreadsheet (16000 Rows with data spanning columns A-H). I
gt; gt; would like to allow user of the spreadsheet to enter a single value into a
gt; gt; cell (A3). I would then like the soreadsheet to search all of the data in
gt; gt; the reference cells, A6:A16023. When a match is located, I would like all
gt; gt; the data in the corresponding row to poulate cells B3:H3.
gt; gt;
gt; gt; Example: User enters 4563542 into cell A3. That value is located in
gt; gt; A11546. I would like B3 to poulate with the data from B11546, C3 with C11546
gt; gt; and so on.
gt; gt;
gt; gt; Is this possible? If so, can you provide the formula, or at least a sample
gt; gt; that I can work from.

you are welcome

quot;Don - Mundane Government Workerquot; escreveu:

gt; Thanks, that got me in the right direction.
gt;
gt; quot;Marceloquot; wrote:
gt;
gt; gt; Don,
gt; gt;
gt; gt; try to create the formulas as:
gt; gt;
gt; gt; On the B3 cell, quot;=vlookup(a3;A6:h16023;2;0)
gt; gt; On the C3 cell, quot;=vlookup(a3;A6:h16023;3;0)
gt; gt; On the D3 cell, quot;=vlookup(a3;A6:h16023;4;0)
gt; gt; On the E3 cell, quot;=vlookup(a3;A6:h16023;5;0)
gt; gt; On the F3 cell, quot;=vlookup(a3;A6:h16023;6;0)
gt; gt; On the G3 cell, quot;=vlookup(a3;A6:h16023;7;0)
gt; gt; On the H3 cell, quot;=vlookup(a3;A6:h16023;8;0)
gt; gt;
gt; gt; As you can see the last number before 0, (...;2;0) refers to the number of
gt; gt; the collunm on the area.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Don - Mundane Government Workerquot; escreveu:
gt; gt;
gt; gt; gt; I have a lengthy spreadsheet (16000 Rows with data spanning columns A-H). I
gt; gt; gt; would like to allow user of the spreadsheet to enter a single value into a
gt; gt; gt; cell (A3). I would then like the soreadsheet to search all of the data in
gt; gt; gt; the reference cells, A6:A16023. When a match is located, I would like all
gt; gt; gt; the data in the corresponding row to poulate cells B3:H3.
gt; gt; gt;
gt; gt; gt; Example: User enters 4563542 into cell A3. That value is located in
gt; gt; gt; A11546. I would like B3 to poulate with the data from B11546, C3 with C11546
gt; gt; gt; and so on.
gt; gt; gt;
gt; gt; gt; Is this possible? If so, can you provide the formula, or at least a sample
gt; gt; gt; that I can work from.