looking up a cell

  • Thread starter Thread starter Uffe Kousgaard
  • Start date Start date
U

Uffe Kousgaard

I have the row() function returning one number and the column() functioning
returning another number, but how do I look up the value in the cell this
refers to? I know without modifying the numbers it would be the same cell,
but I add something to the row() number.

Regards
Uffe
 
One way:

J3: =OFFSET(J3, X, 0)

Where X is the "something" to add to the row number.
 
If you enter following formula in any cell. It will reurn the value of
cell B1.
=INDIRECT("R1C2",0)
You can chage reference by
=INDIRECT("R"& Row()&"C"Column(),0)
 
You must log in or register to reply here.

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

Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Locate text in range (multiple occurrences) and report other cell insame column? 10
Looking for the value that indicates last row number that has filled cells 3
Excel lookup across entire workbook 1
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
help on a formula (match and etc..) 1

Back
Top