| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate row lookup from a cell value
Hi,
I would like to reference one cell to populate the value from another cell, but I want it to find which row to reference from the value in another cell. For example assume cell F1 has a value of 7 and I want cell A1 to reference the cell in column B and whatever row matches the value in F1, so I want it bring in the value from cell B7. If I change the value in cell F1 to 10, then I want cell A1 to refresh and populate the value in B10. So I think it would look like =B(F1) but I can't figure out the syntax. Thanks, Ken |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate row lookup from a cell value
=INDIRECT("B"&F1)
"KPR" skrev: Hi, I would like to reference one cell to populate the value from another cell, but I want it to find which row to reference from the value in another cell. For example assume cell F1 has a value of 7 and I want cell A1 to reference the cell in column B and whatever row matches the value in F1, so I want it bring in the value from cell B7. If I change the value in cell F1 to 10, then I want cell A1 to refresh and populate the value in B10. So I think it would look like =B(F1) but I can't figure out the syntax. Thanks, Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and populate question: | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| how to automatically populate cells using lookup tables | Excel Discussion (Misc queries) | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) | |||
Linear Mode
