John,

I'm not sure I understand what you mean but maybe this

=IF(B6="","",IF(B6=Sheet1!$C$4,ROW()&" "&ROW(Sheet1!$C$4),""))

Mike

"John Moore" wrote:

Hi guys, I am trying to establish if I can use the AND function with IF in
the following formula. The formula below retuns a row number based on the
criteria B6 in current sheet ( Sheet 2 ) if it matches the data in cell C4 of
Sheet 1, I would like the formula to return the same data ( row number )
based in C4 of Sheet 1 and E4 of Sheet 1 ,,,, I've tried adding an AND
statment but couldn't get it to work.




=IF(B6="","",IF(B6=Sheet1!$C$4,ROW(),""))