| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula range
is there any way to make A2 in the formula a function of a cell value?
=VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a range name in formula | Excel Discussion (Misc queries) | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| Formula for a new range..... | Excel Discussion (Misc queries) | |||
| Sum Formula that excludes other sum formula in range | Excel Worksheet Functions | |||
Threaded Mode
