View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default

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


.