Hi!
Then just swap arguments:
=IF(INDIRECT("'"&B$1&"'!"&"C$2"&ROW(A2))+INDIRECT
("'"&B$1&"'!"&"C$4"&ROW(A2))=$B$3,INDIRECT
("'"&B$1&"'!"&C$2&ROW(A2))+INDIRECT("'"&B$1&"'!"&C $4&ROW
(A2)),"")
Biff
-----Original Message-----
Biff,
Ragdyer's advise was based on information that I
presented incorrectly. He
answered my question perfectly, but I asked the question
incorrectly. His
answer gave me a blank for any response< my threshold. I
meant to ask for a
formula that would return a blank for a response not
<. I basically
didn't need the final argument, which confused RD and
hence everything gave
me the "" response.
What I need is my original final response to be the TRUE
response, and a
blank to be the FALSE response.
Thanks,
--
Gary Beard
.
|