How to enter a range address using data elsewhere on the sheet?

G

Guest

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?
 
G

Guest

Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in
the formula evaluating to say G15, if A1 contains text "G15"
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using vlookup to find data outside a specified range 1
vlookup---using data outside the range specified in the formula 4
using the =page! feature to transpose a row to column 0
How do I copy a range of data to another sheet? 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
a data validation list that contains a list of named ranges - not alist from a named range 1
How to create a range address with ADDRESS function? 1
Using Macro how to create email link for the email addresses in aRange or Selection 8

Top