Lookup Funtion

  • Thread starter Don - Mundane Government Worker
  • Start date
D

Don - Mundane Government Worker

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.
 
M

Marcelo

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:
 
D

Don - Mundane Government Worker

Thanks, that got me in the right direction.

Marcelo said:
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:
Click to expand...
 
Top