Conditional formulas between multiple worksheets


G

Guest

Here's the problem:

I want excel to autofill a formula across a range of cells. This formula
has several logical tests in it, and all of these test are mutually
exclusive. When I autofill now, this formula changes the cell values for the
outputs (which I want), but it also changes the inputs for the logical tests
(which I don't). I want excel to lock the logical test cell references when
I autofill, but still change the true/false outputs as normal. More
concretely, if I entered this into A1 of worksheet3:

=(if'worksheet1'!A1,'worksheet2'!B1,'0')

How do I make excel do this:
=(if'worksheet1'!A1,'worksheet2'!B2,'0')

That is, keep A1 locked, but vary B2, instead of:
=(if'worksheet1'!A2,'worksheet2'!B2,'0')

when I autofill A2 of worksheet 3?
 
Ad

Advertisements


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

Top