function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get the result from Sheet1 to Sheet2 if the function has to check
for a few conditions from Sheet1. I tried to use "IF" function but could not
figure out.
Arthur
 
=IF(Sheet1A1="some_value",ID(Sheet1!A2=99,Sheet1!C1,""),"")

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Set non-continuous PrintArea via Function / Name 0
Check for two sheets. Add or subtract as necessary. 2
Excel Moving data to sheet2 from sheet1 0
How Do I Avoid #REF! In Formulas? 4
Inserting data from one worksheet to another 1
use of ADDRESS function within CELL function 4
EXCEL - IF(IFERROR(VLOOKUP question 0
Variable reference in a function 3

Back
Top