Copying formulae

J

jamalhakem

Hi
I have this problem
In AN11 cells in sheet work1 I have this formulae
IF(AND(ISNUMBER(AF11);AG11=TRUE);"No";IF(AND(ISNUMBER(AF11);AG11=FALSE);AM1¬1))
I want to copy the result to the other sheet called names, so I wrote
that in AJ10 in sheet names should be the same results
Work1!AN11
This should be for AJ13 in Sheet names to be as AN15 in sheet work1
Is there any idea
Thanks in advance
Jam
 
S

Simon Lloyd

Im sorry but i couldn't seem to get what you mean from your explanation,
as you have pointed out to display a result from another sheet you use
thsi format =Sheet1!A1 sometimes you need to use the INDIRECT function,
can you try to explain in a little more detail what you have and what
you would like to have happen?
 

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

how to copy and paste value from one sheet to another 4
Using a vlookup to search multiple criteria for one result? 7
combine three if functions 3
trouble with (complicated) vlookup searching another workbook 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Copy addition formula of non-consecutive horizontal cells 2
Excel If statement copy only if ISNumber result is yes 1
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top