Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Funtion
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Funtion
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Funtion
you are welcome
"Don - Mundane Government Worker" escreveu: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup funtion referenced from another sheet. | Excel Worksheet Functions | |||
compicated lookup funtion | Excel Discussion (Misc queries) | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |