Lookup Funtion
Thanks, that got me in the right direction.
"Marcelo" wrote:
Don,
try to create the formulas as:
On the B3 cell, "=vlookup(a3;A6:h16023;2;0)
On the C3 cell, "=vlookup(a3;A6:h16023;3;0)
On the D3 cell, "=vlookup(a3;A6:h16023;4;0)
On the E3 cell, "=vlookup(a3;A6:h16023;5;0)
On the F3 cell, "=vlookup(a3;A6:h16023;6;0)
On the G3 cell, "=vlookup(a3;A6:h16023;7;0)
On the H3 cell, "=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.
"Don - Mundane Government Worker" escreveu:
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.
|