| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
picking out a specific cell in a row
I need to use a cell number in a function that will update itself for each
new row it is in. For example, my function looks like this: VLOOKUP(B3, name, 2, FALSE), where "B3" is the number of the cell I need to use because I'm in row 3. If I were in row 4 the cell number I would use is "B4". I don't want to hard code all of these locations in so I'm wondering if someone knows a way for excel to just update that cell number for each new row I'm in? I tried =VLOOKUP("B"&ROW(), name, 2, FALSE) but that didn't work. I'm using excel 2002. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Picking up part of a formula from another cell | Excel Worksheet Functions | |||
| Picking specific rows from database | Excel Discussion (Misc queries) | |||
| Picking specific records from a table | New Users to Excel | |||
| Picking figures out of a cell | Excel Discussion (Misc queries) | |||
| how do i sort a list from cells by picking a specific letter? | Excel Discussion (Misc queries) | |||
Threaded Mode
