URGENT: Can you insert a formula into a reference ie $B4:$C(row(x


H

HenryB

I can insert a formula like this into lookup and other functions and they
work fine but when trying to insert into a reference, it will allow
$B:C(row()-1) but excel does not recognise it and only thinks there is a
single column in the reference.
There must be a way to do it.
Also, related question, If the value of a variable is the same as the row
number, how can I write a formula that replaces this variable with a row
function.
 
Ad

Advertisements

N

Niek Otten

Look in HELP for the INDIRECT() function.
Second question: ROW()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I can insert a formula like this into lookup and other functions and they
| work fine but when trying to insert into a reference, it will allow
| $B:C(row()-1) but excel does not recognise it and only thinks there is a
| single column in the reference.
| There must be a way to do it.
| Also, related question, If the value of a variable is the same as the row
| number, how can I write a formula that replaces this variable with a row
| function.
|
 

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

I PLEASE NEED URGENT HELP WITH A FORMULA!!! 1
Insert Row also adds formulas and moves cursor 2
How to reference or redirect a formula in a base row? 3
How to change cell reference within formulas 4
need quick help averaging multiple rows 3
Keeping row number after inserting lines 4
Lookup or reference 3 data points 4
Insert rows, keep a formula? 1

Top