function

A

Arthur

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
 
B

Bob Phillips

=IF(Sheet1A1="some_value",ID(Sheet1!A2=99,Sheet1!C1,""),"")

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top