Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter a range address using data elsewhere on the sheet?
I want to enter cell addresses and range addresses in formulas (functions)
such as vlookup using row and column numbers that are calculated elsewhere on the spreadsheet. How do I write the range formula in a manner that takes its cell address parameters from those other cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter a range address using data elsewhere on the sheet?
Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in
the formula evaluating to say G15, if A1 contains text "G15" "TimRTi" wrote: I want to enter cell addresses and range addresses in formulas (functions) such as vlookup using row and column numbers that are calculated elsewhere on the spreadsheet. How do I write the range formula in a manner that takes its cell address parameters from those other cells? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter a range address using data elsewhere on the sheet?
Try INDIRECT
HTH -- AP "TimRTi" a écrit dans le message de ... I want to enter cell addresses and range addresses in formulas (functions) such as vlookup using row and column numbers that are calculated elsewhere on the spreadsheet. How do I write the range formula in a manner that takes its cell address parameters from those other cells? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter a range address using data elsewhere on the sheet?
=VLOOKUP(...,INDEX(Range,X2,Y2),...)
TimRTi wrote: I want to enter cell addresses and range addresses in formulas (functions) such as vlookup using row and column numbers that are calculated elsewhere on the spreadsheet. How do I write the range formula in a manner that takes its cell address parameters from those other cells? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter a range address using data elsewhere on the sheet
Kassie,
This looks to be the Rosetta Stone for me. Thanks. I still need to do some experimenting with it, but a quick check says it works. "kassie" wrote: Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in the formula evaluating to say G15, if A1 contains text "G15" "TimRTi" wrote: I want to enter cell addresses and range addresses in formulas (functions) such as vlookup using row and column numbers that are calculated elsewhere on the spreadsheet. How do I write the range formula in a manner that takes its cell address parameters from those other cells? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter a range address using data elsewhere on the sheet
If you can avoid indirect by for instance using index (index can use other
cells as row and column numbers) than you should do that. indirect is a volatile function so it slows down a workbook since they recalculate where others don't http://www.decisionmodels.com/calcsecretsi.htm -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "TimRTi" wrote in message ... Kassie, This looks to be the Rosetta Stone for me. Thanks. I still need to do some experimenting with it, but a quick check says it works. "kassie" wrote: Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in the formula evaluating to say G15, if A1 contains text "G15" "TimRTi" wrote: I want to enter cell addresses and range addresses in formulas (functions) such as vlookup using row and column numbers that are calculated elsewhere on the spreadsheet. How do I write the range formula in a manner that takes its cell address parameters from those other cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Using forms to enter Data into an Expense Sheet. | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |